public void BindVendor(Int64 BankId)
{
deliveryboyMaster objdeliveryboyMaster = (new Cls_deliveryboy_b().SelectById(BankId));
if (objdeliveryboyMaster != null)
{
txtName.Text = objdeliveryboyMaster.Name;
txtAddress1.Text = objdeliveryboyMaster.Address1;
txtpassword.Text = objdeliveryboyMaster.password;
txtMobileNo1.Text = objdeliveryboyMaster.MobileNo1;
txtLandline.Text = objdeliveryboyMaster.landline;
txtEmail.Text = objdeliveryboyMaster.email;
if (!string.IsNullOrEmpty(objdeliveryboyMaster.img))
{
imgCategory.Visible = true;
ViewState["fileName"] = objdeliveryboyMaster.img;
imgCategory.ImageUrl = categoryFrontPath + objdeliveryboyMaster.img;
btnImageUpload.Visible = false;
btnRemove.Visible = true;
}
else
{
btnImageUpload.Visible = true;
}
}
}
public deliveryboyMaster SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
deliveryboyMaster objVendorMaster = new deliveryboyMaster();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "deliveryboy_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@id", id);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
//vid, vendorName, Address1, Address2, MobileNo1, MobileNo2, email, landline, fk_countryId, fk_stateId, fk_cityId, createddate, isdelete, isactive
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objVendorMaster.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objVendorMaster.Name = Convert.ToString(ds.Tables[0].Rows[0]["Name"]);
objVendorMaster.img = Convert.ToString(ds.Tables[0].Rows[0]["img"]);
objVendorMaster.Address1 = Convert.ToString(ds.Tables[0].Rows[0]["Address1"]);
objVendorMaster.MobileNo1 = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo1"]);
objVendorMaster.password = Convert.ToString(ds.Tables[0].Rows[0]["password"]);
objVendorMaster.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]);
objVendorMaster.landline = Convert.ToString(ds.Tables[0].Rows[0]["landline"]);
objVendorMaster.latitude = Convert.ToString(ds.Tables[0].Rows[0]["latitude"]);
objVendorMaster.loginitude = Convert.ToString(ds.Tables[0].Rows[0]["loginitude"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objVendorMaster);
}
public Int64 Update(deliveryboyMaster objVendorMaster)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "deliveryboy_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objVendorMaster.id;
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Name", objVendorMaster.Name);
cmd.Parameters.AddWithValue("@Address1", objVendorMaster.Address1);
cmd.Parameters.AddWithValue("@MobileNo1", objVendorMaster.MobileNo1);
cmd.Parameters.AddWithValue("@email", objVendorMaster.email);
cmd.Parameters.AddWithValue("@landline", objVendorMaster.landline);
cmd.Parameters.AddWithValue("@img", objVendorMaster.img);
cmd.Parameters.AddWithValue("@password", objVendorMaster.password);
//cmd.Parameters.AddWithValue("@latitude", objVendorMaster.latitude);
//cmd.Parameters.AddWithValue("@loginitude", objVendorMaster.loginitude);
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 btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
deliveryboyMaster objdeliveryboyMaster = new deliveryboyMaster();
objdeliveryboyMaster.Name = txtName.Text.Trim();
objdeliveryboyMaster.Address1 = txtAddress1.Text.Trim();
objdeliveryboyMaster.password = txtpassword.Text.Trim();
objdeliveryboyMaster.MobileNo1 = txtMobileNo1.Text.Trim();
objdeliveryboyMaster.landline = txtLandline.Text.Trim();
objdeliveryboyMaster.email = txtEmail.Text.Trim();
if (ViewState["fileName"] != null)
{
objdeliveryboyMaster.img = ViewState["fileName"].ToString();
}
if (Request.QueryString["id"] != null)
{
objdeliveryboyMaster.id = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
bool res = CheckMobileNumberExitOrNot(objdeliveryboyMaster.MobileNo1, "u", objdeliveryboyMaster.id.ToString());
if (res == true)
{
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Duplicate Mobile No";
}
else
{
Result = (new Cls_deliveryboy_b().Update(objdeliveryboyMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageDeliveryBoy.aspx? mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Delivery Boy Not Updated";
BindVendor(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
}
else
{
bool res = CheckMobileNumberExitOrNot(objdeliveryboyMaster.MobileNo1, "i", "0");
if (res == true)
{
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Duplicate Mobile No";
}
else
{
Result = (new Cls_deliveryboy_b().Insert(objdeliveryboyMaster));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/ManageDeliveryBoy.aspx? mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Delivery Boy Not Inserted";
}
}
}
}
