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