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