/// <summary>
/// Allows user to create a new inward(Tapal entry)
/// </summary>
/// <returns></returns>
public ActionResult Create(int?id)
{
// string aaa = "000";
string slNo = "000";
int TPLNO = id ?? 0;
DateTime startDateTime = DateTime.Today; //Today at 00:00:00
DateTime endDateTime = DateTime.Today.AddDays(1).AddTicks(-1); //Today at 23:59:59
int count = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime).Count();
if (count > 0)
{
slNo += (count + 1);
}
else
{
slNo += 1;
}
slNo = slNo.Substring(slNo.Length - 3, 3);
slNo = "I" + slNo;
sample_User sampleUser = new sample_User();
var subjectlist = user.Subjects.ToList();
sampleUser.subList = subjectlist.Select(m => new SelectListItem()
{
Text = m.Subject_Name,
Value = m.Subject_Name
}).ToList();
sampleUser.T_Sno = slNo;
ViewBag.count1 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "Accounts").Count();
ViewBag.count2 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "Purchase").Count();
ViewBag.count3 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "Recruitment").Count();
ViewBag.count4 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "Dean's Office" && !c.Issue).Count();
ViewBag.count5 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "IPR Cell").Count();
ViewBag.count6 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "ICSR Facilities").Count();
ViewBag.count7 = user.Inwards.Where(c => c.Date_in >= startDateTime && c.Date_in < endDateTime && c.T_Section == "Office").Count();
ViewBag.subject = new SelectList(user.Subjects, "Subject_Name", "Subject_Name");
return(View(sampleUser));
// ViewBag.subject= new SelectList(user.Subjects,"")
}
public ActionResult updatedetails(sample_User samp, FormCollection frm)
{
using (var database = new TapalsEntities())
{
// var tplno = database.Inwards.Max(hc => hc.TPLNO) + 1;
var chequeList = new List <in_Cheque>();
foreach (var key in frm.AllKeys.Where(hc => hc.Contains("MyKey")).ToList())
{
var myKey = key.Replace("MyKey", "");
in_Cheque check = new in_Cheque()
{
AMOUNT = frm["AMOUNT" + myKey],
BANK = frm["BANK" + myKey],
CQDATE = (Convert.ToDateTime(frm["CQDATE" + myKey])),
CQNO = Convert.ToInt64(frm["CQNO" + myKey]),
//TPLNO = Convert.ToInt32(tplno + myKey)
// TPLNO = tplno + myKey
};
chequeList.Add(check);
}
if (chequeList != null && chequeList.Any())
{
using (var dbobj = new TapalsEntities())
{
foreach (var cheque in chequeList)
{
bool isrecordexist = false;
var dbtable = dbobj.Cheques.SingleOrDefault(hc => hc.CQNO == cheque.CQNO);
if (dbtable != null)
{
isrecordexist = true;
}
else
{
dbtable = new Cheque();
}
dbtable.AMOUNT = cheque.AMOUNT;
dbtable.BANK = cheque.BANK;
dbtable.CQDATE = cheque.CQDATE;
dbtable.CQNO = Convert.ToInt32(cheque.CQNO);
//dbtable.TPLNO = tplno1;
if (!isrecordexist)
{
dbobj.Cheques.Add(dbtable);
}
dbobj.SaveChanges();
}
}
}
using (var dbobj = new TapalsEntities())
{
bool isrecordexist = false;
var dbtable = dbobj.Inwards.SingleOrDefault(hc => hc.TPLNO == samp.TPLNO);
if (dbtable != null)
{
}
else
{
string dep = frm["Department"];
dbtable = new Inward();
dbtable.Date_in = DateTime.Now;
dbtable.T_Sno = samp.T_Sno;
dbtable.T_From = samp.T_From;
dbtable.T_Dept = frm["Department"];
dbtable.T_Subject = samp.T_Subject;
dbtable.T_Section = samp.T_Section;
dbtable.T_Passout = samp.T_Passout;
dbtable.TPLNO = "I1526";
dbtable.T_Cheque = "Y";
// dbtable.T_User = Session["UserName"].ToString();
dbtable.T_User = "******";
dbtable.wfcpno = samp.wfcpno;
}
if (!isrecordexist)
{
dbobj.Inwards.Add(dbtable);
}
dbobj.SaveChanges();
}
return(RedirectToAction("Index", "New_Entry"));
}
}
public ActionResult Create(sample_User samp, FormCollection frm)
{
using (var database = new TapalsEntities())
{
var chequeList = new List <in_Cheque>();
if (frm.AllKeys.Any() && frm.AllKeys.Count() > 0)
{
foreach (var key in frm.AllKeys.Where(hc => hc.Contains("MyKey")).ToList())
{
var myKey = key.Replace("MyKey", "");
in_Cheque check = new in_Cheque()
{
AMOUNT = frm["AMOUNT" + myKey],
BANK = frm["BANK" + myKey],
CQDATE = Convert.ToDateTime(frm["CQDATE" + myKey]),
CQNO = Convert.ToInt64(frm["CQNO" + myKey]),
};
chequeList.Add(check);
}
}
if (chequeList != null && chequeList.Any())
{
foreach (var cheque in chequeList)
{
bool isCheckexist = false;
var dbCheckDetails = database.Cheques.SingleOrDefault(hc => hc.CQNO == cheque.CQNO);
if (dbCheckDetails != null)
{
isCheckexist = true;
}
else
{
dbCheckDetails = new Cheque();
}
dbCheckDetails.CQNO = Convert.ToInt32(cheque.CQNO);
dbCheckDetails.TPLNO = (String.Format("{0:ddMMyyyy}", DateTime.Now.Date).Replace(" ", String.Empty)) + (samp.T_Sno);
dbCheckDetails.CQDATE = cheque.CQDATE;
dbCheckDetails.BANK = cheque.BANK;
dbCheckDetails.AMOUNT = cheque.AMOUNT;
if (!isCheckexist)
{
database.Cheques.Add(dbCheckDetails);
}
database.SaveChanges();
}
}
bool isrecordexist = false;
string TapalNo = string.Empty;
var dbInWardDetail = database.Inwards.SingleOrDefault(hc => hc.TPLNO == samp.TPLNO);
if (dbInWardDetail != null)
{
isrecordexist = true;
}
else
{
dbInWardDetail = new Inward();
TapalNo = (String.Format("{0:ddMMyyyy}", DateTime.Now.Date).Replace(" ", String.Empty)) + (samp.T_Sno);
dbInWardDetail.TPLNO = TapalNo;
dbInWardDetail.T_Sno = samp.T_Sno;
dbInWardDetail.T_Cheque = frm["Check1"] != null ? "Y" : "N";
dbInWardDetail.Date_in = DateTime.Now.Date;
}
dbInWardDetail.T_From = samp.T_From;
dbInWardDetail.T_Dept = frm["hdndepartmentDropDown"];
dbInWardDetail.T_Subject = samp.T_Subject;
dbInWardDetail.T_Subject_Value = samp.T_Subject_Value;
dbInWardDetail.T_Section = frm["hdnsectionDropdownId"];
dbInWardDetail.T_User = "******";
dbInWardDetail.T_Passout = samp.T_Passout;
dbInWardDetail.wfcpno = samp.wfcpno;
dbInWardDetail.Issue = false;
if (!isrecordexist)
{
database.Inwards.Add(dbInWardDetail);
}
database.SaveChanges();
if (!string.IsNullOrEmpty(TapalNo))
{
TempData["TapalNo"] = TapalNo;
}
return(RedirectToAction("Create", "Inward"));
}
}
