public static string EditHoarding(string ID)
{
HoardingHistory hoardingHistory = new HoardingHistory();
Hoarding hoarding = new Hoarding();
UserDetail result = new UserDetail();
int HoardingID = Convert.ToInt32(ID);
try
{
hoardingHistory = Global.dc.HoardingHistories.FirstOrDefault(i => i.HoadingHistoryID == HoardingID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
if (hoardingHistory != null)
{
//hoarding.Amount = hoardingHistory.Amount;
//hoarding.FromDate = hoardingHistory.FromDate;
//hoarding.ToDate = hoardingHistory.ToDate;
//hoarding.CityID = hoardingHistory.City;
//hoarding.AreaID = hoardingHistory.Area;
//hoarding.AreaName = hoardingHistory.AreaDetail.Area;
//hoarding.CityName = hoardingHistory.CityDetail.CityName;
//hoarding.HoardingBanner = hoardingHistory.BannerName;
//hoarding.UserID = hoardingHistory.HoardingDetail.UserID;
//hoarding.HoardingNo = hoardingHistory.HoardingNo;
//hoarding.HoardingID = hoardingHistory.HoardingID;
//hoarding.Username = hoardingHistory.HoardingDetail.UserDetail.PersonName;
//hoarding.ID = hoardingHistory.HoadingHistoryID;
}
}
catch (Exception)
{
}
return(new JavaScriptSerializer().Serialize(hoarding));
}
public static string DeleteHoarding(string ID)
{
string result = string.Empty;
try
{
int HoardingID = Convert.ToInt32(ID);
//Remove hoarding history details
HoardingHistory hoardingHistory = Global.dc.HoardingHistories.FirstOrDefault(i => i.HoadingHistoryID == HoardingID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
if (hoardingHistory != null)
{
hoardingHistory.IsDeleted = true;
int count = Global.dc.SaveChanges();
if (count > 0)
{
//HoardingDetail hoarding = Global.dc.HoardingDetails.FirstOrDefault(i => i.HoardingID == hoardingHistory.HoardingID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
//if (hoarding != null)
//{
// count = 0;
// hoarding.IsDeleted = true;
// count = Global.dc.SaveChanges();
// result = count.ToString();
//}
//else
//{
// result = "3";
//}
}
else
{
result = "2";
}
result = Convert.ToString(count);
}
else
{
result = "3";
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
public static string UpdateHoarding(string ID, string HoardingNo, string User, string Area, string City, string FromDate, string ToDate, string Amount, string FileName)
{
// result 0 for not saved
// result -1 for some internal error
// result 1 or greater than 1 for successfuly saved
string result = "0";
UserDetail user = new UserDetail();
HoardingHistory hoarding = new HoardingHistory();
int HoardingHistoryID = Convert.ToInt32(ID);
try
{
hoarding = Global.dc.HoardingHistories.FirstOrDefault(i => i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue) && i.HoadingHistoryID == HoardingHistoryID);
if (hoarding != null)
{
//hoarding.HoardingNo = HoardingNo;
//hoarding.Area = Convert.ToInt32(Area);
//hoarding.City = Convert.ToInt32(City);
//hoarding.FromDate = DateTime.ParseExact(FromDate, "dd/MM/yyyy", null);
//hoarding.ToDate = DateTime.ParseExact(ToDate, "dd/MM/yyyy", null);
//hoarding.Amount = Convert.ToDecimal(Amount);
//if (!string.IsNullOrEmpty(FileName))
//{
// hoarding.BannerName = FileName;
//}
//int count = Global.dc.SaveChanges();
// result = count.ToString();
}
else
{
result = "3";
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
protected void btnHoardingEntry_Click(object sender, EventArgs e)
{
HoardingHistory hoardingHistory = new HoardingHistory();
string originalFilename = string.Empty, replaceFilename = string.Empty;
string accounType = string.Empty;
DateTime fromDate, ToDate;
try
{
fromDate = DateTime.Parse(txtFromDate.Text);
ToDate = DateTime.Parse(txtToDate.Text);
accounType = Request.Form["ddlAccountType"];
if (accounType.ToLower() == "permanent")
{
var result = Global.dc.CheckPermanentEntry(fromDate, ToDate, accounType.ToLower(), Convert.ToInt32(hdnHoardingMasterID.Value)).FirstOrDefault();
if (result != null)
{
Response.Write("<script>alert('Hoarding Entry Already Exist ');</script>");
}
else
{
#region Insert New Entry
// int hoardingID = Global.dc.HoardingHistories.Max(i => i.HoadingHistoryID) + 1;
// hoarding.HoardingID = hoardingID;
hoardingHistory.UserID = Convert.ToInt32(Request.Form["hdnParty"]);
hoardingHistory.HoardingMasterID = Convert.ToInt32(Request.Form["hdnHoardingMasterID"]);
hoardingHistory.IsActive = true;
hoardingHistory.IsDeleted = false;
hoardingHistory.FromDate = fromDate;
hoardingHistory.ToDate = ToDate;
hoardingHistory.Type = accounType.ToLower();
hoardingHistory.Amount = Convert.ToDecimal(txtMonthlyAmount.Text);
string path = "/Images/HoardingImage/";
DirectoryInfo dirInfo = new DirectoryInfo(Server.MapPath(path));
if (!dirInfo.Exists)
{
DirectoryInfo dir = Directory.CreateDirectory(Server.MapPath(path));
}
if (fileHoardingImage.HasFile)
{
if (!Directory.Exists(path))
{
originalFilename = fileHoardingImage.FileName;
replaceFilename = GetTimeStamp() + Path.GetExtension(originalFilename);
fileHoardingImage.SaveAs(Server.MapPath(path) + replaceFilename);
}
}
//Set image file name in database
hoardingHistory.BannerName = replaceFilename;
if (accounType.ToLower() == "permanent")
{
hoardingHistory.IsPermanent = true;
}
else if (accounType.ToLower() == "temporary")
{
hoardingHistory.IsPermanent = false;
}
hoardingHistory.CreatedDate = DateTime.Now;
Global.dc.HoardingHistories.Add(hoardingHistory);
int count = Global.dc.SaveChanges();
if (count > 0)
{
Response.Write("<script>alert('Hoarding Entry done successfully.');</script>");
}
else
{
//Record insertion failed
Response.Write("<script>alert('Some Internal problem');</script>");
}
#endregion
}
}
else if (accounType.ToLower() == "temporary")
{
var result = Global.dc.CheckTemporaryEntry(fromDate, ToDate, accounType.ToLower(), Convert.ToInt32(hdnHoardingMasterID.Value)).ToList();
if (result != null)
{
Response.Write("<script>alert('Temporary Hoarding Entry Already Exist ');</script>");
}
else
{
#region Insert New Entry
// int hoardingID = Global.dc.HoardingHistories.Max(i => i.HoadingHistoryID) + 1;
// hoarding.HoardingID = hoardingID;
hoardingHistory.UserID = Convert.ToInt32(Request.Form["hdnParty"]);
hoardingHistory.HoardingMasterID = Convert.ToInt32(Request.Form["hdnHoardingMasterID"]);
hoardingHistory.IsActive = true;
hoardingHistory.IsDeleted = false;
hoardingHistory.FromDate = fromDate;
hoardingHistory.ToDate = ToDate;
hoardingHistory.Type = accounType.ToLower();
hoardingHistory.Amount = Convert.ToDecimal(txtMonthlyAmount.Text);
string path = "/Images/HoardingImage/";
DirectoryInfo dirInfo = new DirectoryInfo(Server.MapPath(path));
if (!dirInfo.Exists)
{
DirectoryInfo dir = Directory.CreateDirectory(Server.MapPath(path));
}
if (fileHoardingImage.HasFile)
{
if (!Directory.Exists(path))
{
originalFilename = fileHoardingImage.FileName;
replaceFilename = GetTimeStamp() + Path.GetExtension(originalFilename);
fileHoardingImage.SaveAs(Server.MapPath(path) + replaceFilename);
}
}
//Set image file name in database
hoardingHistory.BannerName = replaceFilename;
if (accounType.ToLower() == "permanent")
{
hoardingHistory.IsPermanent = true;
}
else if (accounType.ToLower() == "temporary")
{
hoardingHistory.IsPermanent = false;
}
hoardingHistory.CreatedDate = DateTime.Now;
Global.dc.HoardingHistories.Add(hoardingHistory);
int count = Global.dc.SaveChanges();
if (count > 0)
{
Response.Write("<script>alert('Hoarding Entry done successfully.');</script>");
}
else
{
//Record insertion failed
Response.Write("<script>alert('Some Internal problem');</script>");
}
#endregion
}
}
}
catch (Exception ex)
{
Response.Write("<script>alert('Some Internal problem');</script>");
}
}
public string RenewHoarding(string ID)
{
string result = string.Empty;
int count = 0;
try
{
int HoardingID = Convert.ToInt32(ID);
DateTime toDate;
//Cascade check in hoarding history table
var hoarding = Global.dc.HoardingHistories.FirstOrDefault(i => i.IsActive == true && (!i.IsDeleted.HasValue || !i.IsDeleted.Value) && (!i.IsExpired.HasValue || !i.IsExpired.Value) && i.HoadingHistoryID == HoardingID);
//if not null also needs to check for todate value is greater than current date or not
if (hoarding != null && hoarding.ToDate > DateTime.Now.Date)
{
//if hoarding is not null update record for expire and if successfully expired then renew this hoarding
hoarding.IsExpired = true;
toDate = hoarding.ToDate.Value;
hoarding.ToDate = DateTime.Now.Date;
hoarding.UpdatedDate = DateTime.Now;
count = Global.dc.SaveChanges();
if (count > 0)
{
HoardingHistory renewHoarding = new HoardingHistory();
renewHoarding.UserID = hoarding.UserID;
renewHoarding.HoardingMasterID = hoarding.HoardingMasterID;
renewHoarding.IsPermanent = hoarding.IsPermanent;
renewHoarding.Status = hoarding.Status;
renewHoarding.Type = hoarding.Type;
renewHoarding.FromDate = DateTime.Now.Date;
renewHoarding.ToDate = toDate;
renewHoarding.Amount = hoarding.Amount;
renewHoarding.BannerName = hoarding.BannerName;
renewHoarding.IsActive = true;
renewHoarding.IsDeleted = false;
renewHoarding.IsExpired = false;
renewHoarding.IsRenewed = true;
renewHoarding.CreatedBy = SessionManager.AdminID;
renewHoarding.CreatedDate = DateTime.Now;
Global.dc.HoardingHistories.Add(renewHoarding);
count = 0;
count = Global.dc.SaveChanges();
if (count > 0)
{
result = Convert.ToString(count);
}
else
{
result = "0";
}
}
else
{
result = "0";
}
}
else
{
result = "0";
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
protected void btnHoardingEntry_Click(object sender, EventArgs e)
{
HoardingHistory hoardingHistory = new HoardingHistory();
string originalFilename = string.Empty, replaceFilename = string.Empty;
string accounType = string.Empty;
DateTime fromDate, ToDate;
try
{
#region Date time conversion
fromDate = DateTime.ParseExact(Request.Form["hdnFromDate"], "MM/dd/yy", CultureInfo.InvariantCulture);
ToDate = DateTime.ParseExact(Request.Form["hdnToDate"], "MM/dd/yy", CultureInfo.InvariantCulture);
#endregion
//ToDate = DateTime.Parse(txtToDate.Text);
accounType = Request.Form["ddlAccountType"];
int hoardingMasterID = Convert.ToInt32(hdnHoardingMasterID.Value);
int DayCount = Convert.ToInt32(txtDayOrMonth.Text);
if (accounType.ToLower() == "permanent")
{
var result = Global.dc.CheckPermanentEntry(fromDate, ToDate, accounType.ToLower(), Convert.ToInt32(hdnHoardingMasterID.Value)).FirstOrDefault();
if (result != null)
{
Response.Write("<script>alert('Hoarding Entry Already Exist ');</script>");
}
else
{
#region Insert New Permanent Entry
// int hoardingID = Global.dc.HoardingHistories.Max(i => i.HoadingHistoryID) + 1;
// hoarding.HoardingID = hoardingID;
hoardingHistory.UserID = Convert.ToInt32(Request.Form["hdnParty"]);
hoardingHistory.HoardingMasterID = Convert.ToInt32(Request.Form["hdnHoardingMasterID"]);
hoardingHistory.IsActive = true;
hoardingHistory.IsDeleted = false;
hoardingHistory.IsPermanent = true;
if (ToDate < DateTime.Now)
{
hoardingHistory.IsExpired = true;
}
else
{
hoardingHistory.IsExpired = false;
}
hoardingHistory.FromDate = fromDate;
hoardingHistory.ToDate = ToDate;
hoardingHistory.Type = accounType.ToLower();
hoardingHistory.Amount = Convert.ToDecimal(txtMonthlyAmount.Text);
//set Renew value for insertion
if (!string.IsNullOrEmpty(hdnIsRenew.Value))
{
if (hdnIsRenew.Value.ToLower() == "true")
{
hoardingHistory.IsRenewed = true;
}
else
{
hoardingHistory.IsRenewed = false;
}
}
else
{
hoardingHistory.IsRenewed = false;
}
//end renew code
string path = ConfigurationManager.AppSettings["FolderPath"];
DirectoryInfo dirInfo = new DirectoryInfo(Server.MapPath(path));
if (!dirInfo.Exists)
{
DirectoryInfo dir = Directory.CreateDirectory(Server.MapPath(path));
}
if (fileHoardingImage.HasFile)
{
if (!Directory.Exists(path))
{
originalFilename = fileHoardingImage.FileName;
replaceFilename = GetTimeStamp() + Path.GetExtension(originalFilename);
fileHoardingImage.SaveAs(Server.MapPath(path) + replaceFilename);
hoardingHistory.BannerName = replaceFilename;
}
}
//Set image file name in database
hoardingHistory.IsPermanent = true;
hoardingHistory.CreatedDate = DateTime.Now;
Global.dc.HoardingHistories.Add(hoardingHistory);
int count = Global.dc.SaveChanges();
if (count > 0)
{
Response.Write("<script>alert('Hoarding Entry done successfully.');</script>");
}
else
{
//Record insertion failed
Response.Write("<script>alert('Record insertion failed');</script>");
}
#endregion
}
}
else if (accounType.ToLower() == "temporary")
{
var result = Global.dc.CheckTemporaryEntry(fromDate, ToDate, accounType.ToLower(), Convert.ToInt32(hdnHoardingMasterID.Value)).FirstOrDefault();
if (result != null)
{
Response.Write("<script>alert('Temporary Hoarding Entry Already Exist ');</script>");
}
else
{
var resultPermanentData = Global.dc.HoardingHistories.FirstOrDefault(i => i.Type.ToLower() == "permanent" && i.IsActive == true && (!i.IsDeleted.HasValue || i.IsDeleted == false) && i.HoardingMasterID == hoardingMasterID && i.FromDate <= fromDate && i.ToDate >= ToDate);
var hoardingEntery = Global.dc.CheckPermanentEntry(resultPermanentData.FromDate, resultPermanentData.ToDate.Value.AddDays(DayCount), resultPermanentData.Type, resultPermanentData.HoardingMasterID).FirstOrDefault();
if (hoardingEntery != null)
{
// if future hoarding is booked
Response.Write("<script>alert('Permanent Hoarding Entry Already Exist For Extend days ');</script>");
}
else
{
#region Insert New Temporary Entry
// int hoardingID = Global.dc.HoardingHistories.Max(i => i.HoadingHistoryID) + 1;
// hoarding.HoardingID = hoardingID;
hoardingHistory.UserID = Convert.ToInt32(Request.Form["hdnParty"]);
hoardingHistory.HoardingMasterID = Convert.ToInt32(Request.Form["hdnHoardingMasterID"]);
hoardingHistory.IsActive = true;
hoardingHistory.IsDeleted = false;
hoardingHistory.FromDate = fromDate;
hoardingHistory.IsPermanent = false;
if (ToDate < DateTime.Now)
{
hoardingHistory.IsExpired = true;
}
else
{
hoardingHistory.IsExpired = false;
}
hoardingHistory.ToDate = ToDate;
hoardingHistory.Type = accounType.ToLower();
hoardingHistory.Amount = Convert.ToDecimal(txtMonthlyAmount.Text);
//for temporary Entery Renew is not possible so set it direct to false
hoardingHistory.IsRenewed = false;
string path = ConfigurationManager.AppSettings["FolderPath"];
DirectoryInfo dirInfo = new DirectoryInfo(Server.MapPath(path));
if (!dirInfo.Exists)
{
DirectoryInfo dir = Directory.CreateDirectory(Server.MapPath(path));
}
if (fileHoardingImage.HasFile)
{
if (!Directory.Exists(path))
{
originalFilename = fileHoardingImage.FileName;
replaceFilename = GetTimeStamp() + Path.GetExtension(originalFilename);
fileHoardingImage.SaveAs(Server.MapPath(path) + replaceFilename);
hoardingHistory.BannerName = replaceFilename;
}
}
//Set image file name in database
if (accounType.ToLower() == "permanent")
{
hoardingHistory.IsPermanent = true;
}
else if (accounType.ToLower() == "temporary")
{
hoardingHistory.IsPermanent = false;
}
hoardingHistory.CreatedDate = DateTime.Now;
Global.dc.HoardingHistories.Add(hoardingHistory);
int count = Global.dc.SaveChanges();
if (count > 0)
{
//After temporary entery save update record of permamanet entery by adding extra days to it expire date
//var resultData = Global.dc.CheckPermanentEntry(fromDate, ToDate, "permanent", Convert.ToInt32(hdnHoardingMasterID.Value)).FirstOrDefault();
var resultData = Global.dc.HoardingHistories.FirstOrDefault(i => i.Type.ToLower() == "permanent" && i.IsActive == true && (!i.IsDeleted.HasValue || i.IsDeleted == false) && i.HoardingMasterID == hoardingMasterID && i.FromDate <= fromDate && i.ToDate >= ToDate);
if (resultData != null)
{
resultData.IsActive = false;
resultData.ToDate = resultData.ToDate.Value.AddDays(DayCount);
var cnt = Global.dc.SaveChanges();
}
Response.Write("<script>alert('Hoarding Entry done successfully.');</script>");
}
else
{
//Record insertion failed
Response.Write("<script>alert('Record insertion failed');</script>");
}
#endregion
}
}
}
}
catch (Exception ex)
{
string message = "<script>alert('some internal problem');</script>";
//Response.Write(ex.Message);
hdnError.Value = ex.Message;
Response.Write(message);
//ClientScript.RegisterStartupScript(this.GetType(), "alert", message);
}
}
