public DataTable SelectDealerDetails_usingId(Int64 did) { SqlDataAdapter da; DataTable ds = new DataTable(); dealermaster objdealermaster = new dealermaster(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "getDealerDetails_usingID"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; cmd.Parameters.AddWithValue("@did", did); ConnectionString.Open(); da = new SqlDataAdapter(cmd); da.Fill(ds); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(null); } finally { ConnectionString.Close(); } return(ds); }
protected void btnUpdate_Click(object sender, EventArgs e) { dealermaster objdealermaster = new dealermaster(); objdealermaster.did = Convert.ToInt64(ocommon.Decrypt(Convert.ToString(Request.QueryString["id"]), true)); objdealermaster.name = txtDealerName.Text; objdealermaster.userloginmobileno = txtUserLoginNo.Text; objdealermaster.password = txtPassword.Text; objdealermaster.whatappno = txtWhatappNo.Text; objdealermaster.email = txtEmailId.Text; objdealermaster.gstno = txtGSTNO.Text; objdealermaster.address1 = txtAddress1.Text; objdealermaster.address2 = txtAddress2.Text; objdealermaster.city = txtCity.Text; objdealermaster.state = txtSate.Text; objdealermaster.agentid = Convert.ToInt64(ddlUser.SelectedValue.ToString()); Int64 DID = Update(objdealermaster); if (DID > 0) { Response.Redirect(Page.ResolveUrl("~/managedealer.aspx?mode=u")); } else { spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Dealer Not Updated"; } }
private void BindDealer(string DealerId) { dealermaster objdealermaster = (new Cls_dealermaster_b().SelectById(Convert.ToInt64(DealerId))); if (objdealermaster != null) { txtDealerName.Text = objdealermaster.name; txtUserLoginNo.Text = objdealermaster.userloginmobileno; //txtUserLoginNo.Enabled = false; txtPassword.Text = objdealermaster.password; txtPassword.Enabled = false; txtWhatappNo.Text = objdealermaster.whatappno; txtEmailId.Text = objdealermaster.email; txtGSTNO.Text = objdealermaster.gstno; txtaadharno.Text = objdealermaster.aadharno; txtpanno.Text = objdealermaster.panno; txtAddress1.Text = objdealermaster.address1; txtAddress2.Text = objdealermaster.address2; lstCity.SelectedValue = objdealermaster.city; hfcity.Value = objdealermaster.city; txtSate.SelectedValue = objdealermaster.state; txtSate_SelectedIndexChanged(null, null); ddldistrict.SelectedValue = objdealermaster.district.ToString(); ddlUser.SelectedValue = objdealermaster.agentid.ToString(); txtbalance.Text = objdealermaster.balance.ToString(); } }
public dealermaster SelectById(Int64 did) { SqlDataAdapter da; DataSet ds = new DataSet(); dealermaster objdealermaster = new dealermaster(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "dealermaster_SelectById"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; cmd.Parameters.AddWithValue("@did", did); ConnectionString.Open(); da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { { objdealermaster.did = Convert.ToInt64(ds.Tables[0].Rows[0]["did"]); objdealermaster.name = Convert.ToString(ds.Tables[0].Rows[0]["name"]); objdealermaster.userloginmobileno = Convert.ToString(ds.Tables[0].Rows[0]["userloginmobileno"]); objdealermaster.password = Convert.ToString(ds.Tables[0].Rows[0]["password"]); objdealermaster.whatappno = Convert.ToString(ds.Tables[0].Rows[0]["whatappno"]); objdealermaster.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]); objdealermaster.gstno = Convert.ToString(ds.Tables[0].Rows[0]["gstno"]); objdealermaster.aadharno = Convert.ToString(ds.Tables[0].Rows[0]["aadharno"]); objdealermaster.panno = Convert.ToString(ds.Tables[0].Rows[0]["panno"]); objdealermaster.address1 = Convert.ToString(ds.Tables[0].Rows[0]["address1"]); objdealermaster.address2 = Convert.ToString(ds.Tables[0].Rows[0]["address2"]); objdealermaster.city = Convert.ToString(ds.Tables[0].Rows[0]["city"]); objdealermaster.state = Convert.ToString(ds.Tables[0].Rows[0]["state"]); objdealermaster.guid = Convert.ToString(ds.Tables[0].Rows[0]["guid"]); objdealermaster.agentid = Convert.ToInt64(ds.Tables[0].Rows[0]["FK_agentId"]); objdealermaster.district = Convert.ToInt64(ds.Tables[0].Rows[0]["district"]); objdealermaster.balance = Convert.ToDecimal(ds.Tables[0].Rows[0]["balance"]); } } } } } } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(null); } finally { ConnectionString.Close(); } return(objdealermaster); }
public Int64 Insert(dealermaster objdealermaster) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "dealermaster_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@did"; param.Value = objdealermaster.did; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@name", objdealermaster.name); cmd.Parameters.AddWithValue("@userloginmobileno", objdealermaster.userloginmobileno); cmd.Parameters.AddWithValue("@password", objdealermaster.password); cmd.Parameters.AddWithValue("@whatappno", objdealermaster.whatappno); cmd.Parameters.AddWithValue("@email", objdealermaster.email); cmd.Parameters.AddWithValue("@gstno", objdealermaster.gstno); cmd.Parameters.AddWithValue("@aadharno", objdealermaster.gstno); cmd.Parameters.AddWithValue("@panno", objdealermaster.gstno); cmd.Parameters.AddWithValue("@address1", objdealermaster.address1); cmd.Parameters.AddWithValue("@address2", objdealermaster.address2); cmd.Parameters.AddWithValue("@city", objdealermaster.city); cmd.Parameters.AddWithValue("@state", objdealermaster.state); cmd.Parameters.AddWithValue("@guid", objdealermaster.guid); cmd.Parameters.AddWithValue("@district", objdealermaster.district); cmd.Parameters.AddWithValue("@balance", objdealermaster.balance); ConnectionString.Open(); cmd.ExecuteNonQuery(); result = Convert.ToInt64(param.Value); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(result); } finally { ConnectionString.Close(); } return(result); }
protected void btnUpdate_Click(object sender, EventArgs e) { dealermaster objdealermaster = new dealermaster(); objdealermaster.name = txtDealerName.Text; objdealermaster.userloginmobileno = txtUserLoginNo.Text; objdealermaster.password = txtPassword.Text; objdealermaster.whatappno = txtWhatappNo.Text; objdealermaster.email = txtEmailId.Text; objdealermaster.gstno = txtGSTNO.Text; objdealermaster.aadharno = txtaadharno.Text; objdealermaster.panno = txtpanno.Text; objdealermaster.address1 = txtAddress1.Text; objdealermaster.address2 = txtAddress2.Text; objdealermaster.city = hfcity.Value; objdealermaster.state = txtSate.SelectedValue.ToString(); objdealermaster.district = Convert.ToInt64(ddldistrict.SelectedValue.ToString()); objdealermaster.agentid = Convert.ToInt64(ddlUser.SelectedValue.ToString()); objdealermaster.balance = Convert.ToDecimal(txtbalance.Text.Trim()); if (Request.QueryString["id"] != null) { objdealermaster.did = Convert.ToInt64(ocommon.Decrypt(Convert.ToString(Request.QueryString["id"]), true)); Int64 DID = Update(objdealermaster); if (DID > 0) { Response.Redirect(Page.ResolveUrl("~/managedealer.aspx?mode=u")); } else { spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Dealer Not Updated"; } } else { Int64 Result = (new Cls_dealermaster_b().Insert(objdealermaster)); if (Result > 0) { Clear(); Response.Redirect(Page.ResolveUrl("~/managedealer.aspx?mode=i")); } else { Clear(); spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Dealer Information Not Saved..."; } } }
public Int64 Update(dealermaster objdealermaster) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "dealermaster_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@did"; param.Value = objdealermaster.did; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@name", objdealermaster.name); cmd.Parameters.AddWithValue("@whatappno", objdealermaster.whatappno); cmd.Parameters.AddWithValue("@email", objdealermaster.email); cmd.Parameters.AddWithValue("@gstno", objdealermaster.gstno); cmd.Parameters.AddWithValue("@address1", objdealermaster.address1); cmd.Parameters.AddWithValue("@address2", objdealermaster.address2); cmd.Parameters.AddWithValue("@city", objdealermaster.city); cmd.Parameters.AddWithValue("@state", objdealermaster.state); cmd.Parameters.AddWithValue("@Img", objdealermaster.Img); //cmd.Parameters.AddWithValue("@FK_agentId", objdealermaster.agentid); ConnectionString.Close(); ConnectionString.Open(); cmd.ExecuteNonQuery(); result = Convert.ToInt64(param.Value); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(result); } finally { ConnectionString.Close(); } return(result); }
private void BindDealer(string DealerId) { dealermaster objdealermaster = (new Cls_dealermaster_b().SelectById(Convert.ToInt64(DealerId))); if (objdealermaster != null) { txtDealerName.Text = objdealermaster.name; txtUserLoginNo.Text = objdealermaster.userloginmobileno; //txtUserLoginNo.Enabled = false; txtPassword.Text = objdealermaster.password; txtPassword.Enabled = false; txtWhatappNo.Text = objdealermaster.whatappno; txtEmailId.Text = objdealermaster.email; txtGSTNO.Text = objdealermaster.gstno; txtAddress1.Text = objdealermaster.address1; txtAddress2.Text = objdealermaster.address2; txtCity.Text = objdealermaster.city; txtSate.Text = objdealermaster.state; ddlUser.SelectedValue = objdealermaster.agentid.ToString(); } }