Interested to Buy Any Domain ? << Click Here >> for more details...
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
This post does not have a normal trial docket. You will be assigned to cases where the defendant's crime occurred in your patrol division. How do you feel about not being in the normal trial rotation?
Explain Naomi Campbell's life.
What is the date issue of WCT Certificate Contractor?
If A company give the order for Re-condition of Material party charged the service tax on 70% of basic value and cst on 30% of basic value afainst Form C, is there wct will be applicable, if no, why. Clarified the answer
Hi to all, i worked in TCS ( Bpo ) for 6 months & i left TCS because of my health issues and one main reason was my senior was not good, i always found myself tortured, no doubt that envoirnment of TCS is really very good, and obviously there are lots of benefits for their employees, even i spoke to my process head, my process manager, even with the process HR , i discussed on the problem i am facing and requested them to move me into other process but there is one policy is till the time i will not complete 18 months in the same process they are unable to move me into other process, and i left TCS within 6 months , i informed my seniors , HR that i am not well wont be able to continue and i need some rest, and it was BPO , i was really very disturbed putting headphones whole day , it was quite frustrating , after 1 month i had started receiving letters from tcs that i am absent from my duties and i haven't informed anyone, then i again spoke to my HR and my senior that i am no well and also shared medical certificate , but that time my HR was on 15-20 days leave, and he couldn't check my mail. after some time i have started receiving reminders that i have to report within 24 hours else they will take strict action against me, i was really very depressed because one side i was not able to continue in same process and i was getting mails on mails that i have to report and i need to continue, i was not willing to TCS, my HR was on leave, i was not aware whether he is in office or not, when i received final letter then the very same day i contacted my collegue and he told me that HR is on leave, then i forwarded the same mail with my medical to Head office ( Mumbai ), where from i was getting mails, and i got contact no of 1 HR then she said today you are responding because today u got final letter , and before that there was no information about you. then i got absconded, & i received too much letters that i am absconded and i have to pay 20k, now i am willing to join TCS , not in same process , and i am also working as a HR ,in a small firm, now pls help me and suggest me that can i join TCS again if i will clear that outstanding or is there any chance to join tcs,
Name the chairman of traffic communities ?
If an appellet court bases its opinion on something that was not factual can objection be entered asking for reconsideration
Should anyone be able to serve on a jury?
What effect on the whole of society does someone crashing into a lamppost have? Does a girl scout have a political agenda?
HOW TO GET KANYADAN FROM LABOUR WELFARE FUND ? WHAT ARE NECESSARY DOCUMENTS NEED TO BE ATTATCHED BY US ?
what will be the Journal entry for, Goods sold to james on credit for rupees 20,000.?
I belong from Other Backward Class Category I want to Purchase land of ST category Man . What is Process. ? Please tell me.
i am 27 yr old male, if i marry 17 yr old girl is any problems medically and legally
What do you think is the most important issue facing the legal profession at the moment?
sir if a bank declares NPA on one property and auctioned in bank auction even though the said subject is there in DRT and the Loanee got adverse order and filed the same with ADRT and got permitted to pay the amount and paid the amount to the Bank. sir now the question is will the loanee has to pay the interest to the bank during the NPA declared date to to the date of repayment of the Loan amount.
