protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { CustomDetails model = new CustomDetails(); model.CustomType = (CustomDetailsEnums.CustomDetailsType)Convert.ToInt32(ddlCustomType.SelectedValue); model.Description = txtDescription.Text; model.Name = txtName.Text.Trim(); model.ParlourId = this.ParlourId; model.CreatedBy = this.UserID; int Id = 0; if (string.IsNullOrEmpty(hdnId.Value)) { Id = client.SaveCustomDetails(model); ClearControl(); this.ShowMessage(ref lblMessage, MessageType.Success, "Custom detail saved successfully"); } else { model.Id = Convert.ToInt32(hdnId.Value); client.UpdateCustomDetails(model); this.ShowMessage(ref lblMessage, MessageType.Success, "Custom detail udpated successfully"); } BindAllData(); } }
public static void CustomDetailsDelete(CustomDetails model) { DbParameter[] ObjParam = new DbParameter[3]; ObjParam[0] = new DbParameter("@Id", DbParameter.DbType.Int, 0, model.Id); ObjParam[1] = new DbParameter("@ParlourId", DbParameter.DbType.UniqueIdentifier, 0, model.ParlourId); ObjParam[2] = new DbParameter("@CustomType", DbParameter.DbType.Int, 0, model.CustomType); DbConnection.ExecuteNonQuery(CommandType.StoredProcedure, "CustomDetailsDelete", ObjParam); }
public static int CustomDetailsSave(CustomDetails model) { DbParameter[] ObjParam = new DbParameter[5]; ObjParam[0] = new DbParameter("@Name", DbParameter.DbType.VarChar, 0, model.Name); ObjParam[1] = new DbParameter("@Description", DbParameter.DbType.VarChar, 0, model.Description); ObjParam[2] = new DbParameter("@ParlourId", DbParameter.DbType.UniqueIdentifier, 0, model.ParlourId); ObjParam[3] = new DbParameter("@CreatedBy", DbParameter.DbType.Int, 0, model.CreatedBy); ObjParam[4] = new DbParameter("@CustomType", DbParameter.DbType.Int, 0, model.CustomType); return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, "CustomDetailsSave", ObjParam))); }
private void BindAllDataToControl(int Id) { CustomDetails model = client.GetCustomDetails(this.ParlourId, Id, Convert.ToInt32(ddlCustomType.SelectedValue)); if (model != null) { hdnId.Value = model.Id.ToString(); txtDescription.Text = model.Description; txtName.Text = model.Name; } }
public static void CustomDetailsUpdate(CustomDetails model) { DbParameter[] ObjParam = new DbParameter[6]; ObjParam[0] = new DbParameter("@Id", DbParameter.DbType.Int, 0, model.Id); ObjParam[1] = new DbParameter("@Name", DbParameter.DbType.VarChar, 0, model.Name); ObjParam[2] = new DbParameter("@Description", DbParameter.DbType.VarChar, 0, model.Description); ObjParam[3] = new DbParameter("@ParlourId", DbParameter.DbType.UniqueIdentifier, 0, model.ParlourId); ObjParam[4] = new DbParameter("@CreatedBy", DbParameter.DbType.Int, 0, model.CreatedBy); ObjParam[5] = new DbParameter("@CustomType", DbParameter.DbType.Int, 0, model.CustomType); DbConnection.ExecuteNonQuery(CommandType.StoredProcedure, "CustomDetailsUpdate", ObjParam); }
protected void gvCustom_RowCommand(object sender, GridViewCommandEventArgs e) { string EventType = e.CommandName; switch (EventType) { case "EditCustom": BindAllDataToControl(Convert.ToInt32(e.CommandArgument)); break; case "DeleteCustom": CustomDetails model = new CustomDetails(); model.Id = Convert.ToInt32(e.CommandArgument); model.ParlourId = this.ParlourId; model.CustomType = (CustomDetailsEnums.CustomDetailsType)Convert.ToInt32(ddlCustomType.SelectedValue); client.DeleteCustomDetails(model); model = null; BindAllData(); break; default: break; } }
public void DeleteCustomDetails(CustomDetails model) { CustomDetailsBAL.CustomDetailsDelete(model); }
public void UpdateCustomDetails(CustomDetails model) { CustomDetailsBAL.CustomDetailsUpdate(model); }
public int SaveCustomDetails(CustomDetails model) { return(CustomDetailsBAL.CustomDetailsSave(model)); }
public static void CustomDetailsDelete(CustomDetails model) { CustomDetailsDAL.CustomDetailsDelete(model); }
public static int CustomDetailsSave(CustomDetails model) { return(CustomDetailsDAL.CustomDetailsSave(model)); }