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); }