public ClsReturnValue basie(string username, string password)
{
ClsReturnValue objReturn = new ClsReturnValue();
clsSqlHelper objDBEnging = new clsSqlHelper(clsSettings.strsqlcon);
try
{
string StrQuery = "INSERT dbo.books(fkcourseid,bookname,publishyear,writename,barcode,fkemloyeeid,lastupdate)VALUES (@fkcourseid,@bookname,@publishyear,@writename,@barcode,@fkemloyeeid,@lastupdate)";
Dictionary <string, object> DicData = new Dictionary <string, object>();
DicData.Add("@username", username);
DicData.Add("@password", password);
objDBEnging.objExecuteQuery(StrQuery, clsSqlHelper.QueryExcution.ExecuteNonQuery, DicData);
objReturn.blnSuccess = true;
objReturn.strResponse = "|Data Saved|";
return(objReturn);
}
catch (Exception ex)
{
objReturn.blnSuccess = false;
objReturn.strException = "|Error =" + ex.ToString() + "|";
return(objReturn);
}
finally
{
objDBEnging.blnCloseConnection();
}
}
protected void inputsubmit_Click(object sender, EventArgs e)
{
ClsReturnValue objReturn = new ClsReturnValue();
clsSqlHelper objDBEnging = new clsSqlHelper(clsSettings.strsqlcon);
try
{
string StrQuery = "";
Dictionary <string, object> DicData = new Dictionary <string, object>();
DicData.Add("@firstname", inputName.Text);
DicData.Add("@moblie", inputnumber);
DicData.Add("@emailid", emailid);
DicData.Add("@username", username);
DicData.Add("@password", input);
objDBEnging.objExecuteQuery(StrQuery, clsSqlHelper.QueryExcution.ExecuteNonQuery, DicData);
objReturn.blnSuccess = true;
objReturn.strResponse = "|Data Saved|";
return(objReturn);
}
catch (Exception ex)
{
objReturn.blnSuccess = false;
objReturn.strException = "|Error =" + ex.ToString() + "|";
return(objReturn);
}
finally
{
objDBEnging.blnCloseConnection();
}
}
public ClsReturnValue checkLogin(string strUsername, string strPassword)
{
ClsReturnValue obj = new ClsReturnValue();
return(obj);
}
