public JsonResult add_permissions(int cltId)
{
try
{
reportClientTahseel rt = DB.reportClientTahseel.Where(x => x.cltId == cltId && x.treasuryId == null).SingleOrDefault();
if (rt == null)
{
DateTime current_date = DateTime.Now;
DateTime next_of_current_date = DateTime.Now.AddDays(1); //bokra
double debtor = (double)DB.operations_client.ToList().Where(c => DateTime.Parse(c.get_date, new CultureInfo("ar-AE")) <= next_of_current_date && c.clientId == cltId).Sum(x => x.debtor);
double creditor = (double)DB.operations_client.ToList().Where(c => c.clientId == cltId).Sum(x => x.creditor);
double deserved = Math.Round(debtor - creditor, 5);
reportClientTahseel rep = new reportClientTahseel();
rep.cltId = cltId;
client ct = DB.client.Where(c => c.id == cltId).Single();
rep.cltName = ct.name;
rep.charge = ct.charge;
rep.diserved = deserved;
rep.cltAddress = ct.stay_place_get;
rep.cltAreaName = ct.area.name;
List <phones> phList = DB.phones.Where(p => p.clientId == cltId).ToList();
if (phList.Count == 3)
{
rep.phone1 = phList[0].number;
rep.phone2 = phList[1].number;
rep.phone1 = phList[2].number;
}
else if (phList.Count == 2)
{
rep.phone1 = phList[0].number;
rep.phone2 = phList[1].number;
}
else if (phList.Count == 1)
{
rep.phone1 = phList[0].number;
}
rep.count = DB.reportClientTahseel.Where(r => r.cltId == cltId).ToList().Count + 1;
DB.reportClientTahseel.Add(rep);
DB.SaveChanges();
return(Json(new { msg = "تمت الاضافه بنجاح" }));
}
else
{
return(Json(new { msg = "تمت اضافه هذا العميل من قبل.." }));
}
}
catch
{
return(Json(new { msg = "لم تتم عمليه الاضافه..حاول مره اخري" }));
}
}
public JsonResult delete_clt_permission(int id)
{
try
{
reportClientTahseel rpt = DB.reportClientTahseel.Where(r => r.id == id).Single();
DB.reportClientTahseel.Remove(rpt);
DB.SaveChanges();
return(Json(new { msg = "تمت عمليه الحذف بنجاح" }));
}catch
{
return(Json(new { msg = "لم تتم عمليه الحذف .. حاول مره اخري" }));
}
}
public FileContentResult genReport_recorded <T>(int id, List <T> list, string report_name, string dataset, string title, bool format)
{
LocalReport localReport = new LocalReport();
localReport.ReportPath = Server.MapPath("~/Reports/" + report_name + ".rdlc");
//----------------------------------------------------------------------------------
reportClientTahseel rpt = DB.reportClientTahseel.Where(r => r.id == id).Single();
ReportParameter[] para = new ReportParameter[7];
para[0] = new ReportParameter();
para[0].Name = "cName";
para[0].Values.Add(rpt.cltName.Replace(" ", ""));
para[1] = new ReportParameter();
para[1].Name = "areaName";
para[1].Values.Add(rpt.cltAreaName.Replace(" ", ""));
para[2] = new ReportParameter();
para[2].Name = "address";
para[2].Values.Add(rpt.cltAddress.Replace(" ", ""));
para[3] = new ReportParameter();
para[3].Name = "phone1";
para[3].Values.Add(rpt.phone1.Replace(" ", ""));
para[4] = new ReportParameter();
para[4].Name = "charge";
para[4].Values.Add(rpt.charge.ToString());
para[5] = new ReportParameter();
para[5].Name = "deserved";
para[5].Values.Add(rpt.diserved.ToString());
para[6] = new ReportParameter();
para[6].Name = "printDate";
para[6].Values.Add(DateTime.Now.ToString("dd/MM/yy - hh:mm:ss"));
//----------------------------------------------------------------------------------
localReport.SetParameters(para);
ReportDataSource reportDataSource = new ReportDataSource(dataset, list);
Dictionary <string, string> ps = new Dictionary <string, string>();
ps.Add("date", DateTime.Now.ToString());
CultureInfo cf = new CultureInfo("ar-KW");
ReportParameter dt = new ReportParameter("date", String.Format(cf, "{0:g}", DateTime.Now));
localReport.DataSources.Add(reportDataSource);
string reportType = format ? "PDF" : "Excel";
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + (format ? "PDF" : "Excel") + "</OutputFormat>" +
" <PageWidth>10.5in</PageWidth>" +
" <PageHeight>0.0in</PageHeight>" +
" <MarginTop>0.0in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0.5in</MarginRight>" +
" <MarginBottom>0.0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = localReport.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
return(File(renderedBytes, mimeType));
}
