public int AddFlats(int TotalFloor, int FlatOrder, List <int> FlatNo, List <bool> PreIncrement, List <PLCModel> pmodel, string username, int towerID, string FltType, string FltTSize)
{
PLCService pservice = new PLCService();
int plcCount = pservice.GetPLCCount();
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
for (int i = 1; i <= TotalFloor; i++)
{
int kk = 0;
Floor flo = new Floor();
flo.CrBy = username; flo.CrDate = DateTime.Now;
flo.TowerID = towerID;
flo.FloorName = i.ToString();
flo.FloorNo = i;
context.Floors.Add(flo);
context.SaveChanges();
int jj = 0;
foreach (int flat in FlatNo)
{
int fno = GenFlatNo(i, flat, PreIncrement[jj]);
Flat fl = new Flat();
fl.FlatOrder = FlatOrder;
fl.FlatNo = fno.ToString();
fl.FlatName = fno.ToString();
fl.FloorID = flo.FloorID;
fl.FlatType = FltType;
fl.FlatSizeUnit = "SqFt";
fl.FlatSize = Convert.ToDecimal(FltTSize);
fl.Status = "Available";
context.Flats.Add(fl);
context.SaveChanges();
for (int k = 0; k <= plcCount - 1; k++)
{
var pl = pmodel[kk];
if (pl.PLCID != 0)
{
FlatPLC fpcl = new FlatPLC();
fpcl.CrDate = DateTime.Now;
fpcl.FlatID = fl.FlatID;
fpcl.PLCID = pl.PLCID;
context.FlatPLCs.Add(fpcl);
context.SaveChanges();
}
kk++;
}
jj++;
}
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
}
public string UpdateAssuredCheque(string asid, string chequeNo, string chequeDate, string userName)
{
using (REMSDBEntities context = new REMSDBEntities())
{
if (chequeDate != null && chequeDate != "")
{
DateTimeFormatInfo dtinfo = new DateTimeFormatInfo();
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
int id = Convert.ToInt32(asid);
DateTime dt = Convert.ToDateTime(chequeDate, dtinfo);
var model = context.AssuredReturns.Where(rtn => rtn.AssuredReturnID == id).FirstOrDefault();
model.ChequeNo = chequeNo;
model.ChequeDate = dt;
model.Status = "Updated";
model.ModifyBy = userName;
model.ModifyDate = DateTime.Now;
context.Entry(model).State = EntityState.Modified;
int i = context.SaveChanges();
if (i >= 1)
{
return(model.SaleID.Value.ToString());
}
else
{
return("No");
}
}
}
return("No");
}
public string UpdateAssuredChequeAll(string[] chequeNos, string[] chequeDates, string[] aSids, string userName)
{
using (REMSDBEntities context = new REMSDBEntities())
{
string[] cno = chequeNos;
string[] cdate = chequeDates;
string[] asid = aSids;
string rmsg = "No";
for (int i = 0; i < cno.Length; i++)
{
if (cno[i] != "" && cdate[i] != "")
{
DateTimeFormatInfo dtinfo = new DateTimeFormatInfo();
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
int id = Convert.ToInt32(asid[i]);
DateTime dt = Convert.ToDateTime(cdate[i], dtinfo);
var model = context.AssuredReturns.Where(rtn => rtn.AssuredReturnID == id).FirstOrDefault();
model.ChequeNo = cno[i];
model.ChequeDate = dt;
model.Status = "Updated";
model.ModifyBy = userName;
model.ModifyDate = DateTime.Now;
context.Entry(model).State = EntityState.Modified;
int ii = context.SaveChanges();
if (ii >= 1)
{
rmsg = model.SaleID.Value.ToString();
}
}
}
return(rmsg);
}
}
public int AddProject(ProjectModel model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
if (model.PossessionDateSt != null)
{
model.PossessionDate = Convert.ToDateTime(model.PossessionDateSt, FormData.IndianDateFormat());
}
Mapper.CreateMap <ProjectModel, Project>();
var mdl = Mapper.Map <ProjectModel, Project>(model);
mdl.RecordStatus = 0;
mdl.CrDate = DateTime.Now;
mdl.ReceiptNo = "0";
context.Projects.Add(mdl);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public void LogException(Exception exception)
{
// try-catch because database itself could be down or Request context is unknown.
try
{
int?userId = null;
try { userId = 0; }
catch { /* do nothing */ }
// ** Prototype pattern. the Error object has it default values initialized
var error = new Error()
{
UserName = userId.Value.ToString(),
Exception = exception.GetType().FullName,
Message = exception.Message,
Everything = exception.ToString(),
IpAddress = HttpContext.Current.Request.UserHostAddress,
UserAgent = HttpContext.Current.Request.UserAgent,
PathAndQuery = HttpContext.Current.Request.Url == null ? "" : HttpContext.Current.Request.Url.PathAndQuery,
HttpReferer = HttpContext.Current.Request.UrlReferrer == null ? "" : HttpContext.Current.Request.UrlReferrer.PathAndQuery,
CreatedOn = DateTime.Now,
ChangedOn = DateTime.Now
};
using (REMSDBEntities context = new REMSDBEntities())
{
context.Errors.Add(error);
context.SaveChanges();
}
//DealSiteContext.Errors.Insert(error);
}
catch { /* do nothing, or send email to webmaster*/ }
}
public int AddTower(Tower tower)
{
using (var context = new REMSDBEntities())
{
context.Towers.Add(tower);
int i = context.SaveChanges();
return(i);
}
}
public int EditTower(Tower tower)
{
using (var context = new REMSDBEntities())
{
context.Towers.Add(tower);
context.Entry(tower).State = EntityState.Modified;
int i = context.SaveChanges();
return(i);
}
}
public int EditFloor(Floor floor)
{
using (var context = new REMSDBEntities())
{
context.Floors.Add(floor);
context.Entry(floor).State = EntityState.Modified;
int i = context.SaveChanges();
return(i);
}
}
public int DeleteFlat(int flatid)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
FlatPLCService fpservice = new FlatPLCService();
FlatChargeService fcservice = new FlatChargeService();
var model = fpservice.GetFlatPLCListByFlatID(flatid);
foreach (var md in model)
{
FlatPLC plc = new FlatPLC();
plc.FlatPLCID = md.FlatPLCID;
context.FlatPLCs.Add(plc);
context.Entry(plc).State = EntityState.Deleted;
context.SaveChanges();
}
var fmodel = fcservice.GetFlatChargeListByFlatID(flatid);
foreach (var md in fmodel)
{
FlatCharge plc = new FlatCharge();
plc.FlatChargeID = md.FlatChargeID;
context.FlatCharges.Add(plc);
context.Entry(plc).State = EntityState.Deleted;
context.SaveChanges();
}
Flat ft = new Flat();
ft.FlatID = flatid;
context.Flats.Add(ft);
context.Entry(ft).State = EntityState.Deleted;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int AddFloor(Floor floor)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
context.Floors.Add(floor);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int AddFlatTypeSize(FlatTypeSize model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
context.FlatTypeSizes.Add(model);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int AddPlanTypeMaster(PlanTypeMaster model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
context.PlanTypeMasters.Add(model);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int EditFlatTypeSize(FlatTypeSize model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
context.FlatTypeSizes.Add(model);
context.Entry(model).State = EntityState.Modified;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int DeletePlanInstallment(PlanInstallment model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
context.PlanInstallments.Add(model);
context.Entry(model).State = EntityState.Deleted;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int AddPlanInstallment(PlanInstallmentModel model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
Mapper.CreateMap <PlanInstallmentModel, PlanInstallment>();
var mdl = Mapper.Map <PlanInstallmentModel, PlanInstallment>(model);
context.PlanInstallments.Add(mdl);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int AddProjectType(ProjectTypeModel model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
Mapper.CreateMap <ProjectTypeModel, ProjectType>();
var mdl = Mapper.Map <ProjectTypeModel, ProjectType>(model);
context.ProjectTypes.Add(mdl);
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int DeleteFloor(int floorid)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
Floor fl = new Floor();
fl.FloorID = floorid;
context.Floors.Add(fl);
context.Entry(fl).State = EntityState.Deleted;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public string UpdateAssuredChequeUnClearance(string asId, string userName)
{
using (REMSDBEntities context = new REMSDBEntities())
{
int id = Convert.ToInt32(asId);
var model = context.AssuredReturns.Where(rtn => rtn.AssuredReturnID == id).FirstOrDefault();
model.Status = "Updated";
model.ModifyBy = userName;
model.ModifyDate = DateTime.Now;
context.Entry(model).State = EntityState.Modified;
int i = context.SaveChanges();
if (i >= 1)
{
return(model.SaleID.Value.ToString());
}
else
{
return("No");
}
}
}
public int DeletePLC(PLCModel model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
Mapper.CreateMap <PLCModel, PLC>();
var mdl = Mapper.Map <PLCModel, PLC>(model);
context.PLCs.Add(mdl);
context.Entry(mdl).State = EntityState.Deleted;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public int EditProject(ProjectModel model)
{
using (REMSDBEntities context = new REMSDBEntities())
{
try
{
Mapper.CreateMap <ProjectModel, Project>();
var mdl = Mapper.Map <ProjectModel, Project>(model);
context.Projects.Add(mdl);
context.Entry(mdl).State = EntityState.Modified;
int i = context.SaveChanges();
return(i);
}
catch (Exception ex)
{
Helper hp = new Helper();
hp.LogException(ex);
return(0);
}
}
}
public string GetInstallmentByInstallId(int installmentID, string modifyDate)
{
DateTimeFormatInfo dtinfo = new DateTimeFormatInfo();
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
DateTime dt = new DateTime();
if (modifyDate != null && modifyDate != "")
{
using (REMSDBEntities context = new REMSDBEntities())
{
var fl = context.FlatInstallmentDetails.Where(s => s.InstallmentID == installmentID).FirstOrDefault <FlatInstallmentDetail>();
fl.DueDate = dt;
context.SaveChanges();
}
return("Event Completion date updated.");
}
else
{
return("Invalid Date format.");
}
}
public string SaveUsersRights(string username, string modulelist, string notinaccess)
{
try
{
REMSDBEntities context = new REMSDBEntities();
string[] pids = modulelist.Split(',');
if (pids.Length > 0)
{
foreach (string pid in pids)
{
var UAM = context.UserAccesses.Where(ua => ua.UserName == username && ua.ModuleListID == pid).FirstOrDefault();
if (UAM == null)
{
// Insert
int mid = Convert.ToInt32(pid);
var Mdl = context.ModuleLists.Where(md => md.ModuleListID == mid).FirstOrDefault();
UserAccess us = new UserAccess();
us.UserName = username;
us.IsRead = true; us.IsWrite = true;
us.ControllerName = Mdl.Controller;
us.ActionName = Mdl.ActionName;
us.AssignDate = DateTime.Now;
us.AssignUser = User.Identity.Name;
us.ModuleListID = pid;
context.UserAccesses.Add(us);
int i = context.SaveChanges();
}
else
{
// Update
UAM.IsRead = true;
UAM.IsWrite = true;
UAM.AssignUser = User.Identity.Name;
UAM.AssignDate = DateTime.Now;
context.UserAccesses.Add(UAM);
context.Entry(UAM).State = EntityState.Modified;
int i = context.SaveChanges();
}
}
}
string[] llist = notinaccess.Split(',');
foreach (string pid in llist)
{
var UAM = context.UserAccesses.Where(ua => ua.UserName == username && ua.ModuleListID == pid).FirstOrDefault();
if (UAM == null)
{
}
else
{
// Delete
context.UserAccesses.Add(UAM);
context.Entry(UAM).State = EntityState.Deleted;
int i = context.SaveChanges();
}
}
return("Users Access Rights Saved.");
}
catch (Exception ex)
{
hp.LogException(ex);
return("Error!, Please try again.");
}
}
public async Task <string> AddUser(UserModel model)
{
string[] pids = model.Property.Split(',');
if (pids.Length > 0)
{
var user = new ApplicationUser()
{
UserName = model.UserName, Email = model.EmailID
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
Roles.AddUserToRole(model.UserName, model.RoleName);
// await SignInAsync(user, isPersistent: false);
// Add Users Property
REMSDBEntities context = new REMSDBEntities();
foreach (string pid in pids)
{
UserProperty up = new UserProperty();
up.UserName = model.UserName;
up.ProjectID = Convert.ToInt32(pid);
up.AssignUser = User.Identity.Name;
up.AssignDate = DateTime.Now;
context.UserProperties.Add(up);
int i = context.SaveChanges();
}
var roleacc = context.RoleAccesses.Where(ro => ro.RoleName == model.RoleName).ToList();
List <RoleAccess> ra = new List <RoleAccess>();
foreach (var r in roleacc)
{
ra.Add(r);
}
foreach (var ro in ra)
{
//ra.Add(ro);
UserAccess us = new UserAccess();
us.UserName = model.UserName;
us.IsRead = true; us.IsWrite = true;
us.ControllerName = ro.ControllerName;
us.ActionName = ro.ActionName;
us.AssignDate = DateTime.Now;
us.AssignUser = User.Identity.Name;
us.ModuleListID = ro.ModuleListID;
context.UserAccesses.Add(us);
int i = context.SaveChanges();
}
}
if (result.Succeeded)
{
return("User Added Successfully.");
}
else
{
string st = "";
foreach (var er in result.Errors)
{
st += er.ToString();
}
return(st);
}
}
else
{
return("Please select any one Property for User");
}
}
public void SaveInstallments(string saledate, string saleprice, string salepriceword, int ddlInstallment, int ddlInterval, string eventName, string bspPercentage, string saleId, string flatId, string evName, string amount, string pplPrice)
{
REMSDBEntities context = new REMSDBEntities();
DateTimeFormatInfo dtinfo = new DateTimeFormatInfo();
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
DateTime dt2 = DateTime.Now;
if (saledate != "")
dt2 = Convert.ToDateTime(saledate, dtinfo);
var st = context.SaleFlats.Where(s => s.SaleID == Convert.ToInt32(saleId)).FirstOrDefault<SaleFlat>();
st.SaleRate = Convert.ToDecimal(saleprice);
st.SaleRateInWords = salepriceword;
st.SaleDate = dt2;
st.Status = "1";
context.SaveChanges();
StringBuilder l_StringBuilder = new StringBuilder();
string PlanType = "";
amount = amount.Replace("undefined,", "");
amount = amount.TrimEnd(',');
string[] amounts = amount.Split(',');
evName = evName.Replace("undefined,", "");
evName = evName.TrimEnd(',');
string[] EvNames = evName.Split(',');
string[] bspPer = bspPercentage.Split(',');
var fsz = context.Flats.Where(s => s.FlatID == Convert.ToInt32(flatId)).ToList()[0].FlatSize;
decimal.Parse(saleprice) * decimal.Parse(fsz.ToString());
if (PlanType == "1")
{
DataTable tb = new DataTable();
if (Session["table"] != null)
{
tb = Session["table"] as DataTable;
}
if (tb.Rows.Count > 0)
{
string[] EventIdd = EventName.Split(',');
int j = 0;
for (int a = 0; a < tb.Rows.Count; a++)
{
string InstallmentID = Convert.ToString(tb.Rows[a]["InstallmentID"]);
string InstallmentNo = Convert.ToString(tb.Rows[a]["InstallmentNo"]);
if (a > 0)
{
InstallmentNo = a.ToString();
}
string DueAmount = Convert.ToString(tb.Rows[a]["DueAmount"]);
string EventID = Convert.ToString(tb.Rows[a]["EventID"]);
string TotalAmount = Convert.ToString(tb.Rows[a]["TotalAmount"]);
if (DueAmount != "")
{
Hashtable ht = new Hashtable();
ht.Add("DueAmount", DueAmount);
ht.Add("DueAmtInWords", clsnew.rupees(Convert.ToInt64(DueAmount)));
ht.Add("TotalAmount", saleprice);
ht.Add("TotalAmtInWords", clsnew.rupees(Convert.ToInt64(saleprice)));
ht.Add("SaleID", Convert.ToInt32(Session["SaleID"].ToString()));
ht.Add("InstallmentNo", InstallmentNo);
ht.Add("EventName", InstallmentNo);
if (!String.IsNullOrEmpty(Convert.ToString(tb.Rows[a]["DueDate"])))
{
ht.Add("DueDate", obj.Text_IndianDateFormat(Convert.ToString(tb.Rows[a]["DueDate"])));
}
ht.Add("FlatID", Convert.ToInt32(Session["FlatID"].ToString()));
if (Session["TowerID"] != null)
{
ht.Add("TowerID", Convert.ToInt32(Session["TowerID"].ToString()));
}
if (InstallmentNo == "Booking Amount" || InstallmentNo == "Possession Amount")
{
ht.Add("Type", 0);
}
else
{
j++;
ht.Add("Type", 1);
}
ht.Add("Activity", "ADD");
if (obj.ExecuteProcedure("InsertInstallmentDetail", ht))
{
}
}
}
}
}
else if (PlanType == "2")
{
DataTable tb = new DataTable();
#region Construction Based Plan
if (Session["table"] != null)
{
tb = Session["table"] as DataTable;
}
if (tb.Rows.Count > 0)
{
string[] EventIdd = EventName.Split(',');
int j = 0;
for (int a = 0; a < tb.Rows.Count; a++)
{
string InstallmentID = Convert.ToString(tb.Rows[a]["InstallmentID"]);
string InstallmentNo = Convert.ToString(tb.Rows[a]["InstallmentNo"]);
string DueAmount = Convert.ToString(tb.Rows[a]["DueAmount"]);
string EventID = Convert.ToString(tb.Rows[a]["EventID"]);
string TotalAmount = Convert.ToString(tb.Rows[a]["TotalAmount"]);
string DueDate = Convert.ToString(tb.Rows[a]["DueDate"]);
if (DueAmount != "")
{
Hashtable ht = new Hashtable();
ht.Add("DueAmount", amounts[a]);
ht.Add("DueAmtInWords", clsnew.rupees(Convert.ToDecimal(amounts[a])));
ht.Add("TotalAmount", amounts[a]);
ht.Add("TotalAmtInWords", clsnew.rupees(Convert.ToDecimal(amounts[a])));
ht.Add("SaleID", Convert.ToInt32(Session["SaleID"].ToString()));
if (DueDate != "")
{
ht.Add("DueDate", obj.Text_IndianDateFormat(Convert.ToString(tb.Rows[a]["DueDate"]))); /* Balkrishna Add one Line By */
}
ht.Add("FlatID", Convert.ToInt32(Session["FlatID"].ToString()));
if (Session["TowerID"] != null)
{
ht.Add("TowerID", Convert.ToInt32(Session["TowerID"].ToString()));
}
if (InstallmentNo.Contains("Booking Amount") || InstallmentNo.Contains("Possession Amount"))
{
ht.Add("Type", 0);
ht.Add("InstallmentNo", InstallmentNo);
ht.Add("EventName", InstallmentNo);
}
else
{
if (!String.IsNullOrWhiteSpace(EventIdd[j]))
{ ht.Add("EventID", Convert.ToInt32(EventIdd[j])); }
ht.Add("EventName", EvNames[j]);
ht.Add("InstallmentNo", EvNames[j]);
j++;
ht.Add("Type", 1);
}
ht.Add("Activity", "ADD");
ht.Add("Bsp", bspPer[a]);
if (obj.ExecuteProcedure("[InsertInstallmentDetail]", ht))
{
}
}
}
}
#endregion
}
else if (PlanType == "3")
{
#region Normal Mode
DataTable dt = new DataTable();
if (Session["table"] != null)
dt = (DataTable)Session["table"];
//string EventName="";
for (int a = 0; a < dt.Rows.Count; a++)
{
string InstallmentID = Convert.ToString(a + 1);// Convert.ToString(dt.Rows[a]["InstallmentID"]);
EventName = Convert.ToString(dt.Rows[a]["Event"]);
string EventID = "0";
string InstallmentNo = Convert.ToString(dt.Rows[a]["Event"]);// Convert.ToString(dt.Rows[a]["InstallmentNo"]);
string DueDate = Convert.ToString(dt.Rows[a]["DueDate"]);
string DueAmount = Convert.ToString(dt.Rows[a]["Amount"]);
if (DueAmount != "")
{
Hashtable ht = new Hashtable();
if (DueDate != "")
{
ht.Add("DueDate", Convert.ToDateTime(DueDate, dtinfo));
}
ht.Add("DueAmount", amounts[a]);
ht.Add("DueAmtInWords", clsnew.rupees(Convert.ToInt64(amounts[a])));
// ht.Add("ServiceTaxAmount",ServiceTaxAmount.Text);
ht.Add("TotalAmount", amounts[a]);
ht.Add("TotalAmtInWords", clsnew.rupees(Convert.ToInt64(amounts[a])));
ht.Add("SaleID", Convert.ToInt32(Session["SaleID"].ToString()));
ht.Add("InstallmentNo", InstallmentNo);
ht.Add("FlatID", Convert.ToInt32(Session["FlatID"].ToString()));
ht.Add("Type", 0);
ht.Add("UserID", Convert.ToInt32("0"));
ht.Add("Activity", "Add");
ht.Add("EventName", EventName);
ht.Add("EventID", EventID);
ht.Add("FloorNo", 0);
ht.Add("TowerID", 0);
ht.Add("BID", 0);
ht.Add("BSP", bspPer[a]);
if (obj.ExecuteProcedure("InsertInstallmentDetailCLP", ht))
{
}
}
}
#endregion
}
else if (PlanType == "4" || PlanType == "5")
{
DataTable tb = new DataTable();
#region Combo Plan
if (Session["table"] != null)
{
tb = Session["table"] as DataTable;
}
if (tb.Rows.Count > 0)
{
string[] EventIdd = EventName.Split(',');
int j = 0;
for (int a = 0; a < tb.Rows.Count; a++)
{
string InstallmentID = Convert.ToString(tb.Rows[a]["InstallmentID"]);
string InstallmentNo = Convert.ToString(tb.Rows[a]["InstallmentNo"]);
string DueAmount = Convert.ToString(tb.Rows[a]["DueAmount"]);
string EventID = Convert.ToString(tb.Rows[a]["EventID"]);
string Eventorder = Convert.ToString(tb.Rows[a]["EventID"]);
string DueDate = "";
string TotalAmount = Convert.ToString(tb.Rows[a]["TotalAmount"]);
if (DueAmount != "")
{
Hashtable ht = new Hashtable();
if (InstallmentNo.Contains("Booking Amount"))
{
ht.Add("DueDate", obj.Text_IndianDateFormat(saledate));
}
if (DueDate != "")
{
ht.Add("DueDate", obj.Text_IndianDateFormat(DueDate));
}
ht.Add("DueAmount", amounts[a]);
ht.Add("DueAmtInWords", clsnew.rupees(Convert.ToDecimal(amounts[a])));
ht.Add("TotalAmount", amounts[a]);
ht.Add("TotalAmtInWords", clsnew.rupees(Convert.ToDecimal(amounts[a])));
ht.Add("SaleID", Convert.ToInt32(Session["SaleID"].ToString()));
ht.Add("FlatID", Convert.ToInt32(Session["FlatID"].ToString()));
if (Session["TowerID"] != null)
{
ht.Add("TowerID", Convert.ToInt32(Session["TowerID"].ToString()));
}
ht.Add("saleprice", saleprice);
ht.Add("InstallmentOrder", Eventorder);
if (InstallmentNo == "Booking Amount" || InstallmentNo == "Possession Amount")
{
ht.Add("Type", 0);
ht.Add("EventID", 0);
ht.Add("EventName", InstallmentNo);
ht.Add("InstallmentNo", InstallmentNo);
}
else
{
if (!String.IsNullOrWhiteSpace(EventIdd[j]))
{ ht.Add("EventID", Convert.ToInt32(EventIdd[j])); }
ht.Add("EventName", EvNames[j]);
ht.Add("InstallmentNo", EvNames[j]);
j++;
ht.Add("Type", 1);
}
ht.Add("Activity", "ADD");
if (bspPer[a] != null && !String.IsNullOrWhiteSpace(bspPer[a]))
{
ht.Add("Bsp", bspPer[a]);
}
if (obj.ExecuteProcedure("InsertInstallmentDetailCombo", ht))
{
}
}
}
}
#endregion
}
}