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