Answer Posted / santro
/*DrugNames DalCls.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;
using System.Windows.Forms;
using System.IO;
using MedWare;
/// <summary>
/// Summary description for DrugNamesDalCls
/// </summary>
public class DrugNamesDalCls
{
MySqlConnection mysqlcon = new MySqlConnection
(System.Configuration.ConfigurationManager.AppSettings
["strDrugs"].ToString());
public DrugNamesDalCls()
{
//
// TODO: Add constructor logic here
//
}
public void ErrorMsg(string strError)
{
string strErrorPath =
HttpContext.Current.Server.MapPath("Errordetails.txt");
using (FileStream fs = File.Open(strErrorPath,
FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
sw.WriteLine
("..........................................................
............................");
//sw.WriteLine("ApplicationName:" +
strAppUrl);
sw.WriteLine("Error:" + strError);
sw.WriteLine("Creation Date:" +
DateTime.Now);
sw.WriteLine
("..........................................................
............................");
}
}
}
//FUNCTION FOR INSERT TRANSACTION.
public int InsertDrugName(string pstrDrugName)
{
int irec = 0;
string strDate=DateTime.Now.ToString();
//string strIns = "INSERT INTO DRUGNAME VALUES('" +
pstrDrugName + "')";
string strIns = "INSERT INTO DRUGNAME (DrugName)
values('" + pstrDrugName + "')";
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strIns);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
//FUNCTION FOR UPDATE TRANSACTION.
public int UpdateDrugName(string strDrugName, string
DrugNameID)
{
int irec = 0;
string strUpdate = "UPDATE drugname SET DRUGNAME='"
+ strDrugName + "' WHERE DRUGNAMEID=" + DrugNameID;
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strUpdate);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
// FUNCTION FOR DELETE TRANSACTION.
public int DeleteDrugName(string strDrugNameID)
{
int irec = 0;
string strDel = "DELETE FROM drugname WHERE
drugname='" + strDrugNameID + "'";
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strDel);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
}
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
bank does not give loan unless they ascetain full repayment of their loan,then why need of collateral securities
what is MOI????
My company registration is from Mumbai. I have import the good at Chennai port. Now I can sell in Chennai trader in 2% CST OR what is processed to sell the goods of import.
Most of the time you will be required to work without direct supervision. Tell me about times when you were given this autonomy and why you believe you are best suited for this position?
an apple vendor has x apples. for the first customer, he sells half the apple and half an apple. for the second and third customers, he sells half the apple and half of an apple. at last, he has no apples left. how much did he have?
ano ngaba ang nauna manok ba o itlog
What is the difference between manslaughter and murder? What is its significance?
if customer will not able to give form then in bill which tax should i charge
AS PER THE AP VALUE ADDED TAX ACT 2005 LEAFLET 14 VIDE ITEM (1)(A) IF AN AGENT SELLS ANY GOODS ON BEHALF OF THE AGRICULTURIST PRINCIPAL HE IS UNDER NO OBLIGATION TO OBTAIN REGISTRATION UNDER THE AP VAT ACT. BUT AFTER ADDITION OF SUB SECTION 10(a) UNDER SECTION 4 WHAT IS THE POSITION OF AGENT WHO SELLS GOODS ON BEHALF OF AGRICULTURIST PRINCIPAL. IS IT NECESSARY FOR HIM TO OBTAIN REGISTRATION UNDER THE APVAT ACT. PLEASE CLARIFY?
We will be receive Form-F from Our Delhi Unit but he tell us that FORM -F issue quarterly . But our Noida Sales Tax Deptt. required Monthly For the F.Y.2006-07 & 2007-08
MR.VARUN HAS BEEN PAID TOTAL WAGES OF RS.65,560 INCLUDS OVERTIME PAYMENT OF RS.16,400 .HE IS COVERED UNDER PAYMENT OF GRATUITY ACT,1972. 15 DAYS SALARY OF MR VARUN FOR CALCULATION OF GRATUITY WILL BE.
Can a computer have a conscience?
what is valid cell
Ceiling on eligible loan amount and capital subsidy Latest guidelines by Government of India under scheme CLCSS Term loan are being forwarded for your reference. As per this, we can avail a long, accordingly Maximum limit of eligible loan under the scheme is Rs.100 lakhs and ceiling on Capital subsidy is 15% of eligible plant & machinery subject to maximum of Rs.15.00 lakhs.
"Every contract involves an agreement but every agreement does not necessarily result in a contract" Explain.
