public transporter SelectById(Int64 did)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
transporter objtransporter = new transporter();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "transporter_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@id", 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)
{
{
objtransporter.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objtransporter.name = Convert.ToString(ds.Tables[0].Rows[0]["name"]);
objtransporter.mobileno = Convert.ToString(ds.Tables[0].Rows[0]["mobileno"]);
objtransporter.phoneno = Convert.ToString(ds.Tables[0].Rows[0]["phoneno"]);
objtransporter.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]);
objtransporter.gstno = Convert.ToString(ds.Tables[0].Rows[0]["gstno"]);
objtransporter.gsttype = Convert.ToString(ds.Tables[0].Rows[0]["gsttype"]);
objtransporter.aadharno = Convert.ToString(ds.Tables[0].Rows[0]["aadharno"]);
objtransporter.panno = Convert.ToString(ds.Tables[0].Rows[0]["panno"]);
objtransporter.address = Convert.ToString(ds.Tables[0].Rows[0]["address"]);
objtransporter.remark = Convert.ToString(ds.Tables[0].Rows[0]["remark"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objtransporter);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
transporter objtransporter = new transporter();
objtransporter.name = txtname.Text.Trim();
objtransporter.mobileno = txtmobileno.Text.Trim();
objtransporter.phoneno = txtphoneno.Text.Trim();
objtransporter.email = txtemail.Text.Trim();
objtransporter.aadharno = txtaadharno.Text.Trim();
objtransporter.panno = txtpanno.Text.Trim();
objtransporter.gstno = txtgstno.Text.Trim();
objtransporter.gsttype = ddlgsttype.SelectedValue;
objtransporter.address = txtAddress.Text.Trim();
objtransporter.remark = txtremark.Text.Trim();
if (Request.QueryString["id"] != null)
{
objtransporter.id = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_transporter_b().Update(objtransporter));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managetransporters.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Transporter Not Updated";
BindTransporter(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_transporter_b().Insert(objtransporter));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managetransporters.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Transporter Not Saved";
}
}
}
public Int64 Insert(transporter objtransporter)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "transporter_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objtransporter.id;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@name", objtransporter.name);
cmd.Parameters.AddWithValue("@mobileno", objtransporter.mobileno);
cmd.Parameters.AddWithValue("@phoneno", objtransporter.phoneno);
cmd.Parameters.AddWithValue("@email", objtransporter.email);
cmd.Parameters.AddWithValue("@gstno", objtransporter.gstno);
cmd.Parameters.AddWithValue("@gsttype", objtransporter.gsttype);
cmd.Parameters.AddWithValue("@aadharno", objtransporter.aadharno);
cmd.Parameters.AddWithValue("@panno", objtransporter.panno);
cmd.Parameters.AddWithValue("@address", objtransporter.address);
cmd.Parameters.AddWithValue("@remark", objtransporter.remark);
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);
}
public void BindTransporter(Int64 Id)
{
transporter objTransporter = (new Cls_transporter_b().SelectById(Id));
if (objTransporter != null)
{
txtname.Text = objTransporter.name;
txtAddress.Text = objTransporter.address;
txtmobileno.Text = objTransporter.mobileno;
txtphoneno.Text = objTransporter.phoneno;
txtemail.Text = objTransporter.email;
txtgstno.Text = objTransporter.gstno;
ddlgsttype.SelectedValue = objTransporter.gsttype;
txtaadharno.Text = objTransporter.aadharno;
txtpanno.Text = objTransporter.panno;
txtremark.Text = objTransporter.remark;
}
else
{
Clear();
}
}
