private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
MealPlanDTO oMealPlanData = MapControlsToObjects();
MealPlanMaster oMealPlanMaster = new MealPlanMaster();
bActionCompleted = oMealPlanMaster.Insert(oMealPlanData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
ClearControls();
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
oMealPlanData = null;
oMealPlanMaster = null;
}
public bool Delete(MealPlanDTO oMealPlanData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_MealPlanMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPlanId", DbType.Int32, oMealPlanData.MealPlanId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oMealPlanData = null;
GF.LogError("clsMealPlanMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(MealPlanDTO oMealPlanData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_MealPlanMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPlanId", DbType.Int32, oMealPlanData.MealPlanId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlanCode", DbType.String, oMealPlanData.MealPlanCode);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlan", DbType.String, oMealPlanData.MealPlan);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlanDesc", DbType.String, oMealPlanData.MealPlanDesc);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bWelcomeDrink", DbType.Boolean, oMealPlanData.WelcomeDrink);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bBreakFast", DbType.Boolean, oMealPlanData.Breakfast);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bLunch", DbType.Boolean, oMealPlanData.Lunch);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bEveSnacks", DbType.Boolean, oMealPlanData.EveningSnacks);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bDinner", DbType.Boolean, oMealPlanData.Dinner);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oMealPlanData = null;
GF.LogError("clsMealPlanMaster.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
MealPlanMaster oMealPlanMaster = new MealPlanMaster();
MealPlanDTO oMealPlanData = new MealPlanDTO();
oMealPlanData.MealPlanId = Id;
/*
* ADDED BY VIJAY
* CHECK IF THE FLOOR WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "mealplan", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oMealPlanMaster.Delete(oMealPlanData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
ClearControls();
RefreshGrid();
//lblStatus.Text = "Deleted";
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oMealPlanData = null;
oMealPlanMaster = null;
}
private MealPlanDTO MapControlsToObjects()
{
MealPlanDTO oMealPlanData = new MealPlanDTO();
oMealPlanData.MealPlanCode = Convert.ToString(txtMealPlanCode.Text);
oMealPlanData.MealPlan = Convert.ToString(txtMealPlanName.Text);
oMealPlanData.MealPlanDesc = Convert.ToString(txtMealPlanDesc.Text);
if (chkWelcomeDrink.Checked == true)
{
oMealPlanData.WelcomeDrink = true;
}
else
{
oMealPlanData.WelcomeDrink = false;
}
if (chkBreakfast.Checked == true)
{
oMealPlanData.Breakfast = true;
}
else
{
oMealPlanData.Breakfast = false;
}
if (chkLunch.Checked == true)
{
oMealPlanData.Lunch = true;
}
else
{
oMealPlanData.Lunch = false;
}
if (chkEveSnacks.Checked == true)
{
oMealPlanData.EveningSnacks = true;
}
else
{
oMealPlanData.EveningSnacks = false;
}
if (chkDinner.Checked == true)
{
oMealPlanData.Dinner = true;
}
else
{
oMealPlanData.Dinner = false;
}
return(oMealPlanData);
}
public MealPlanDTO[] GetMeals(int MealPlanId)
{
MealPlanDTO[] oMealPlanData = null;
string sProcName = "up_Get_MealPlans";
DatabaseManager oDB = new DatabaseManager();
DataSet ds = null;
//int iVal = 0;
try
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPlanId", DbType.Int32, MealPlanId);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
#region Populating Object
oMealPlanData = new MealPlanDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oMealPlanData[i] = new MealPlanDTO();
oMealPlanData[i].MealPlanId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
oMealPlanData[i].MealPlanCode = Convert.ToString(ds.Tables[0].Rows[i][1]);
oMealPlanData[i].MealPlan = Convert.ToString(ds.Tables[0].Rows[i][2]);
if (ds.Tables[0].Rows[i][3] != DBNull.Value)
{
oMealPlanData[i].WelcomeDrink = Convert.ToBoolean(ds.Tables[0].Rows[i][3]);
}
if (ds.Tables[0].Rows[i][4] != DBNull.Value)
{
oMealPlanData[i].Breakfast = Convert.ToBoolean(ds.Tables[0].Rows[i][4]);
}
if (ds.Tables[0].Rows[i][5] != DBNull.Value)
{
oMealPlanData[i].Lunch = Convert.ToBoolean(ds.Tables[0].Rows[i][5]);
}
if (ds.Tables[0].Rows[i][6] != DBNull.Value)
{
oMealPlanData[i].EveningSnacks = Convert.ToBoolean(ds.Tables[0].Rows[i][6]);
}
if (ds.Tables[0].Rows[i][7] != DBNull.Value)
{
oMealPlanData[i].Dinner = Convert.ToBoolean(ds.Tables[0].Rows[i][7]);
}
}
#endregion Populating Object
}
}
catch (Exception exp)
{
GF.LogError("clsMealPlanMaster.GetMeals", exp.Message);
}
return(oMealPlanData);
}
public MealPlanDTO GetMealDetails(int MealPlanId)
{
MealPlanDTO oMealPlanData = null;
oMealPlanData = null;
DataSet ds;
if (MealPlanId == 0)
{
return(oMealPlanData);
}
string query = "select MealPlanId, MealPlanCode, MealPlan, " +
" WelcomeDrink, BreakFast, Lunch, EveSnacks, Dinner,MealPlanDesc from tblMealPlanMaster where 1=1";
if (MealPlanId != 0)
{
query += " and MealPlanId=" + MealPlanId;
query += " order by MealPlanCode";
}
ds = GetDataFromDB(query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oMealPlanData = new MealPlanDTO();
oMealPlanData.MealPlanId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
oMealPlanData.MealPlanCode = Convert.ToString(ds.Tables[0].Rows[0][1]);
oMealPlanData.MealPlan = Convert.ToString(ds.Tables[0].Rows[0][2]);
if (ds.Tables[0].Rows[0][3] != DBNull.Value && !ds.Tables[0].Rows[0][3].Equals(string.Empty))
{
oMealPlanData.WelcomeDrink = Convert.ToBoolean(ds.Tables[0].Rows[0][3]);
}
if (ds.Tables[0].Rows[0][4] != DBNull.Value && !ds.Tables[0].Rows[0][4].Equals(string.Empty))
{
oMealPlanData.Breakfast = Convert.ToBoolean(ds.Tables[0].Rows[0][4]);
}
if (ds.Tables[0].Rows[0][5] != DBNull.Value && !ds.Tables[0].Rows[0][5].Equals(string.Empty))
{
oMealPlanData.Lunch = Convert.ToBoolean(ds.Tables[0].Rows[0][5]);
}
if (ds.Tables[0].Rows[0][6] != DBNull.Value && !ds.Tables[0].Rows[0][6].Equals(string.Empty))
{
oMealPlanData.EveningSnacks = Convert.ToBoolean(ds.Tables[0].Rows[0][6]);
}
if (ds.Tables[0].Rows[0][7] != DBNull.Value && !ds.Tables[0].Rows[0][7].Equals(string.Empty))
{
oMealPlanData.Dinner = Convert.ToBoolean(ds.Tables[0].Rows[0][7]);
}
oMealPlanData.MealPlanDesc = Convert.ToString(ds.Tables[0].Rows[0][8]);
}
return(oMealPlanData);
}
protected void dgMealPlans_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int iMealPlanID = Convert.ToInt32(dgMealPlans.DataKeys[e.Item.ItemIndex].ToString());
MealPlanMaster oMealPlanMaster = new MealPlanMaster();
MealPlanDTO oMealPlanData = new MealPlanDTO();
oMealPlanData.MealPlanId = iMealPlanID;
oMealPlanMaster.Delete(oMealPlanData);
txtMealPlanName.Text = "";
txtMealPlanCode.Text = "";
txtMealPlanDesc.Text = "";
RefreshGrid();
oMealPlanData = null;
oMealPlanMaster = null;
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
MealPlanDTO oMealPlanData = MapControlsToObjects();
oMealPlanData.MealPlanId = Id;
MealPlanMaster oMealPlanMaster = new MealPlanMaster();
bActionCompleted = oMealPlanMaster.Update(oMealPlanData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
ClearControls();
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oMealPlanData = null;
oMealPlanMaster = null;
}
protected void dgMealPlans_SelectedIndexChanged(object sender, EventArgs e)
{
int iMealPlanID = 0;
int.TryParse(Convert.ToString(dgMealPlans.DataKeys[dgMealPlans.SelectedIndex]), out iMealPlanID);
hfId.Value = iMealPlanID.ToString();
//SessionHandler"MealPlanID"] = iMealPlanID;
MealPlanMaster oMealPlanMaster = new MealPlanMaster();
MealPlanDTO oMealPlanData = oMealPlanMaster.GetMealDetails(iMealPlanID);
txtMealPlanCode.Text = oMealPlanData.MealPlanCode.ToString();
txtMealPlanName.Text = oMealPlanData.MealPlan.ToString();
if (oMealPlanData.MealPlanDesc != null)
{
txtMealPlanDesc.Text = oMealPlanData.MealPlanDesc.ToString();
}
else
{
txtMealPlanDesc.Text = "";
}
if (oMealPlanData.WelcomeDrink == true)
{
chkWelcomeDrink.Checked = true;
}
else
{
chkWelcomeDrink.Checked = false;
}
if (oMealPlanData.Breakfast == true)
{
chkBreakfast.Checked = true;
}
else
{
chkBreakfast.Checked = false;
}
if (oMealPlanData.Lunch == true)
{
chkLunch.Checked = true;
}
else
{
chkLunch.Checked = false;
}
if (oMealPlanData.EveningSnacks == true)
{
chkEveSnacks.Checked = true;
}
else
{
chkEveSnacks.Checked = false;
}
if (oMealPlanData.Dinner == true)
{
chkDinner.Checked = true;
}
else
{
chkDinner.Checked = false;
}
oMealPlanMaster = null;
oMealPlanData = null;
//btnAddNew.Enabled = false;
//btnCancel.Enabled = true;
btnCancel.Visible = true;
btnDelete.Enabled = true;
btnEdit.Text = "Update";
//btnEdit.Enabled = true;
//btnSave.Enabled = false;
lblStatus.Text = "";
}
