private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
bool bActionCompleted;
AccomActivityDTO oAccomWiseActivityData = new AccomActivityDTO();
AccomActivityMaster oAccomWiseActivityMaster = new AccomActivityMaster();
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
oAccomWiseActivityData.AccomodationId = Id;
bActionCompleted = oAccomWiseActivityMaster.Delete(oAccomWiseActivityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
ClearControls();
lblStatus.Text = "Deleted";
}
else
{
lblStatus.Text = "Error Occured while updating: Please refer to the error log.";
}
oAccomWiseActivityMaster = null;
oAccomWiseActivityData = null;
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
AccomActivityDTO oAccomWiseActivityData = new AccomActivityDTO();
AccomActivityMaster oAccomWiseActivityMaster = new AccomActivityMaster();
bool bActionCompleted;
oAccomWiseActivityData = MapControlsToObject();
bActionCompleted = oAccomWiseActivityMaster.Insert(oAccomWiseActivityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been insert successfully");
ClearControls();
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while saving: Please refer to the error log.";
}
oAccomWiseActivityData = null;
oAccomWiseActivityMaster = null;
}
public bool Delete(AccomActivityDTO oAccomActivityData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_AccomActivityMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, oAccomActivityData.AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iActivityId", DbType.Int32, oAccomActivityData.ActivityId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsAccomWiseActivityMaster.Delete", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
bool bActionCompleted;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
if (txtActivityName.Text.Trim() == "")
{
lblStatus.Text = "Please enter the Activity Name.";
return;
}
if (txtActivityDesc.Text.Trim() == "")
{
lblStatus.Text = "Please enter the Activity Description.";
return;
}
AccomActivityDTO oAccomWiseActivityData = null;
AccomActivityMaster oAccomWiseActivityMaster = new AccomActivityMaster();
oAccomWiseActivityData = MapControlsToObject();
oAccomWiseActivityData.ActivityId = Id;
bActionCompleted = oAccomWiseActivityMaster.Update(oAccomWiseActivityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
ClearControls();
lblStatus.Text = "Updated Successfully";
}
else
{
lblStatus.Text = "Error Occured while updating: Please refer to the error log.";
}
oAccomWiseActivityData = null;
oAccomWiseActivityMaster = null;
}
private AccomActivityDTO MapControlsToObject()
{
AccomActivityDTO oAccomWiseActivityData = new AccomActivityDTO();
//DateTime dt;
int id = 0;
int.TryParse(hfAccomId.Value, out id);
oAccomWiseActivityData.AccomodationId = id;
id = 0;
int.TryParse(hfId.Value, out id);
oAccomWiseActivityData.ActivityId = id;
oAccomWiseActivityData.ActivityName = txtActivityName.Text.Trim();
oAccomWiseActivityData.ActivityDesc = txtActivityDesc.Text.Trim();
return(oAccomWiseActivityData);
}
public AccomActivityDTO[] GetData(int AccomodationId, int ActivityId)
{
DataSet ds;
AccomActivityDTO[] AccomWiseActivityData;
AccomWiseActivityData = null;
ds = null;
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "Up_Get_AccomActivities";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ActivityId", DbType.Int32, ActivityId);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
AccomWiseActivityData = new AccomActivityDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AccomWiseActivityData[i] = new AccomActivityDTO();
AccomWiseActivityData[i].AccomodationId = ds.Tables[0].Rows[i][0] != DBNull.Value ? Convert.ToInt32(ds.Tables[0].Rows[i][0]) : 0;
AccomWiseActivityData[i].AccomodationName = ds.Tables[0].Rows[i][1] != DBNull.Value ? Convert.ToString(ds.Tables[0].Rows[i][1]) : "";
AccomWiseActivityData[i].ActivityId = ds.Tables[0].Rows[i][2] != DBNull.Value ? Convert.ToInt32(ds.Tables[0].Rows[i][2]) : 0;
AccomWiseActivityData[i].ActivityName = ds.Tables[0].Rows[i][3] != DBNull.Value ? Convert.ToString(ds.Tables[0].Rows[i][3]) : "";
AccomWiseActivityData[i].ActivityDesc = ds.Tables[0].Rows[i][4] != DBNull.Value ? Convert.ToString(ds.Tables[0].Rows[i][4]) : "";
}
}
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString());
oDB = null;
}
finally
{
oDB = null;
}
return(AccomWiseActivityData);
}
