private void GetData()
{
try
{
List <Segment> data = new SegmentDAL().GetSegments();
Session["SegmentData"] = data.OrderBy(x => x.SegmentOrder).ThenBy(x => x.SegmentName).ToList();
BindGrid();
LoadDropDown();
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void LoadDropDown()
{
try
{
List <Segment> lstSegment = new SegmentDAL().GetSegments().Where(x => x.Status == "A" && x.AccountCodeFlag == false).OrderBy(x => x.SegmentOrder).ToList();
gvSegmentDLLs.DataSource = lstSegment;
gvSegmentDLLs.DataBind();
//GridView: Period
List <PeriodMenguru> lstPeriodMengurus = new PeriodMengurusDAL().GetPeriodMengurus().Where(x => x.Status == "A" && x.MengurusYear > DateTime.Now.Year)
.OrderBy(x => x.MengurusYear).ThenBy(x => x.FieldMenguru.FieldMengurusDesc).ToList();
List <FieldMenguru> obj = new FieldMenguruDAL().GetFieldMengurus().Where(x => x.Status == "F").ToList();
Session["FixedFieldMengurus"] = obj;
foreach (FieldMenguru item in obj)
{
PeriodMenguru pm = new PeriodMenguru();
pm.PeriodMengurusID = item.FieldMengurusID;
pm.MengurusYear = DateTime.Now.Year;
pm.FieldMenguru = new FieldMenguru {
FieldMengurusDesc = item.FieldMengurusDesc
};
lstPeriodMengurus.Add(pm);
}
gvPeriod.DataSource = lstPeriodMengurus.Select(x => new
{
x.PeriodMengurusID,
x.MengurusYear,
x.FieldMenguru.FieldMengurusDesc
});
gvPeriod.DataBind();
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if ((Helper.PageMode)Session["SegmentPageMode"] == Helper.PageMode.New)
{
if (new SegmentDAL().GetSegments().Where(x => x.SegmentName.ToUpper().Trim() == tbSegName.Text.ToUpper().Trim()).Count() > 0)
{
((SiteMaster)this.Master).ShowMessage("Failure", "Segment already exists");
return;
}
if (new SegmentDAL().GetSegments().Where(x => x.SegmentOrder == Convert.ToInt32(tbSegOrder.Text.Trim())).Count() > 0)
{
((SiteMaster)this.Master).ShowMessage("Failure", "Please change Segment order");
return;
}
Segment objSegment = new Segment();
objSegment.SegmentName = tbSegName.Text.Trim();
objSegment.ShapeFormat = string.Empty.PadRight(tbSegFormat.Text.Trim().Length, '?');
objSegment.SegmentOrder = Convert.ToInt32(tbSegOrder.Text.Trim());
objSegment.Status = new Helper().GetItemStatusEnumValueByName(ddlStatus.SelectedValue);
objSegment.CreatedBy = LoggedInUser.UserID;
objSegment.CreatedTimeStamp = DateTime.Now;
objSegment.ModifiedBy = LoggedInUser.UserID;
objSegment.ModifiedTimeStamp = DateTime.Now;
objSegment.AccountCodeFlag = (cdaccflag.Checked) ? true : false;
if (new SegmentDAL().InsertSegment(objSegment))
{
((SiteMaster)this.Master).ShowMessage("Success", "Segment saved successfully");
}
else
{
((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while saving Segment");
}
}
else if ((Helper.PageMode)Session["SegmentPageMode"] == Helper.PageMode.Edit)
{
Segment objSegment = (Segment)Session["SelectedSegment"];
Segment seg = new SegmentDAL().GetSegments().Where(x => x.SegmentOrder == Convert.ToInt32(tbSegOrder.Text.Trim())).FirstOrDefault();
if (seg != null)
{
if (seg.SegmentID != objSegment.SegmentID)
{
((SiteMaster)this.Master).ShowMessage("Failure", "Please change Segment order");
return;
}
}
objSegment.SegmentName = tbSegName.Text.Trim();
objSegment.ShapeFormat = string.Empty.PadRight(tbSegFormat.Text.Trim().Length, '?');
objSegment.SegmentOrder = Convert.ToInt32(tbSegOrder.Text.Trim());
objSegment.Status = new Helper().GetItemStatusEnumValueByName(ddlStatus.SelectedValue);
objSegment.ModifiedBy = LoggedInUser.UserID;
objSegment.ModifiedTimeStamp = DateTime.Now;
objSegment.AccountCodeFlag = (cdaccflag.Checked) ? true : false;
if (new SegmentDAL().UpdateSegment(objSegment))
{
((SiteMaster)this.Master).ShowMessage("Success", "Segment updated successfully");
}
else
{
((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while updating Segment");
}
}
GetData();
ClearPageData();
EditForm.Visible = false;
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
