public void BindEmployee(Int64 BankId) { employeeMaster objVendorMaster = (new Cls_Employee_b().SelectById(BankId)); if (objVendorMaster != null) { txtEmployeeName.Text = objVendorMaster.employeeName; txtAddress1.Text = objVendorMaster.Address1; txtMobileNo1.Text = objVendorMaster.MobileNo1; txtLandline.Text = objVendorMaster.landline; txtEmail.Text = objVendorMaster.email; if (!string.IsNullOrEmpty(objVendorMaster.img)) { imgCategory.Visible = true; ViewState["fileName"] = objVendorMaster.img; imgCategory.ImageUrl = categoryFrontPath + objVendorMaster.img; btnImageUpload.Visible = false; btnRemove.Visible = true; } else { btnImageUpload.Visible = true; } } }
public employeeMaster SelectById(Int64 id) { SqlDataAdapter da; DataSet ds = new DataSet(); employeeMaster objemployeeMaster = new employeeMaster(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "employee_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) { objemployeeMaster.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]); objemployeeMaster.employeeName = Convert.ToString(ds.Tables[0].Rows[0]["employeeName"]); objemployeeMaster.img = Convert.ToString(ds.Tables[0].Rows[0]["img"]); objemployeeMaster.Address1 = Convert.ToString(ds.Tables[0].Rows[0]["Address1"]); objemployeeMaster.MobileNo1 = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo1"]); objemployeeMaster.Password = Convert.ToString(ds.Tables[0].Rows[0]["emppassword"]); objemployeeMaster.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]); objemployeeMaster.landline = Convert.ToString(ds.Tables[0].Rows[0]["landline"]); objemployeeMaster.createddate = Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]); } } } } } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(null); } finally { ConnectionString.Close(); } return(objemployeeMaster); }
protected void btnSave_Click(object sender, EventArgs e) { Int64 Result = 0; employeeMaster objemployeeMaster = new employeeMaster(); objemployeeMaster.employeeName = txtEmployeeName.Text.Trim(); objemployeeMaster.Address1 = txtAddress1.Text.Trim(); objemployeeMaster.MobileNo1 = txtMobileNo1.Text.Trim(); objemployeeMaster.Password = txtpassword.Text.Trim(); objemployeeMaster.landline = txtLandline.Text.Trim(); objemployeeMaster.email = txtEmail.Text.Trim(); if (ViewState["fileName"] != null) { objemployeeMaster.img = ViewState["fileName"].ToString(); } if (Request.QueryString["id"] != null) { objemployeeMaster.id = Convert.ToInt32(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)); Result = (new Cls_Employee_b().Update(objemployeeMaster)); if (Result > 0) { Clear(); Response.Redirect(Page.ResolveUrl("~/manageEmployee.aspx?mode=u")); } else { Clear(); spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Employee Not Updated"; BindEmployee(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true))); } } else { Result = (new Cls_Employee_b().Insert(objemployeeMaster)); if (Result > 0) { Clear(); Response.Redirect(Page.ResolveUrl("~/manageEmployee.aspx?mode=i")); } else { Clear(); spnMessgae.Style.Add("color", "red"); spnMessgae.InnerText = "Employee Not Inserted"; } } }
public Int64 Insert(employeeMaster objemployeeMaster) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "employee_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@id"; param.Value = objemployeeMaster.id; param.SqlDbType = SqlDbType.Int; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@employeeName", objemployeeMaster.employeeName); cmd.Parameters.AddWithValue("@img", objemployeeMaster.img); cmd.Parameters.AddWithValue("@Address1", objemployeeMaster.Address1); cmd.Parameters.AddWithValue("@MobileNo1", objemployeeMaster.MobileNo1); cmd.Parameters.AddWithValue("@password", objemployeeMaster.Password); cmd.Parameters.AddWithValue("@email", objemployeeMaster.email); cmd.Parameters.AddWithValue("@landline", objemployeeMaster.landline); 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); }