public ActionResult MasterDropTable()
{
DataTable dt = new DataTable();
AllMail.MasterList(dt);
List <DSRCManagementSystem.Models.MasterList.masterdroplist> objmodel = new List <Models.MasterList.masterdroplist>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.MasterList.masterdroplist obj = new DSRCManagementSystem.Models.MasterList.masterdroplist();
obj.Name = dt.Rows[i]["name"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "name", "name");
ViewBag.MasterTable = list;
TempData["message"] = "Addeds";
return(View());
}
public ActionResult MasterDropTable(DSRCManagementSystem.Models.MasterList Name)
{
if (Name._drpMasterName == null)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var selectedTable = Name._drpMasterName;
Session["selectmasterTableName"] = selectedTable;
Session["masterTableName"] = Name._drpMasterName;
var selectMaster = db.Sp_Master(selectedTable).ToList();
var ColumnName = db.Sp_GetColumn(selectedTable).ToList();
var columndatatype = db.Sp_MasterDataType(selectedTable).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
ViewBag.columndatatype = columndatatype;
ViewBag.ColumnName = ColumnName;
for (int i = 0; i <= columndatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columndatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columndatatype[i]));
}
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
Name._masterjoin = new List <masterjoin>();
foreach (var s in selectMaster)
{
var rs = s.Split('^').ToArray();
cs.id.Add(rs[0]);
cs.value.Add(rs[1]);
Name._masterjoin.Add(new masterjoin(rs[0].ToString(), rs[1].ToString()));
}
DataTable dt = new DataTable();
AllMail.MasterList(dt);
List <DSRCManagementSystem.Models.MasterList.masterdroplist> objmodel = new List <Models.MasterList.masterdroplist>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.MasterList.masterdroplist obj = new DSRCManagementSystem.Models.MasterList.masterdroplist();
obj.Name = dt.Rows[i]["name"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "name", "name");
ViewBag.MasterTable = list;
TempData["message"] = "Added";
// return View("<script language='javascript' type='text/javascript'>alert('Select MasterTableName ');</script>");
// return Content("<script language='javascript' type='text/javascript'>alert('Select MasterTableName ');</script>");
return(View());
}
else
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var selectedTable = Name._drpMasterName;
Session["selectmasterTableName"] = selectedTable;
Session["masterTableName"] = Name._drpMasterName;
var selectMaster = db.Sp_Master(selectedTable).ToList();
var ColumnName = db.Sp_GetColumn(selectedTable).ToList();
var columndatatype = db.Sp_MasterDataType(selectedTable).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
ViewBag.columndatatype = columndatatype;
ViewBag.ColumnName = ColumnName;
for (int i = 0; i <= columndatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columndatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columndatatype[i]));
}
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
Name._masterjoin = new List <masterjoin>();
foreach (var s in selectMaster)
{
var rs = s.Split('^').ToArray();
cs.id.Add(rs[0]);
cs.value.Add(rs[1]);
Name._masterjoin.Add(new masterjoin(rs[0].ToString(), rs[1].ToString()));
}
DataTable dt = new DataTable();
AllMail.MasterList(dt);
List <DSRCManagementSystem.Models.MasterList.masterdroplist> objmodel = new List <Models.MasterList.masterdroplist>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.MasterList.masterdroplist obj = new DSRCManagementSystem.Models.MasterList.masterdroplist();
obj.Name = dt.Rows[i]["name"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "name", "name");
ViewBag.MasterTable = list;
return(View(Name));
}
}
public ActionResult ExcelReport()
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var reportnamelist = db.Reports1.ToList();
ViewBag.reportname_list = new SelectList(new[] { new Report1()
{
ReportId = 0, ReportName = "---Select---"
} }.Union(reportnamelist), "ReportId", "ReportName", 0);
DataTable dt = new DataTable();
AllMail.GetReportingPerson(dt);
string sourceFile = Server.MapPath("~/Template/EmployeeReportingPerson.xlt");
string ExcelFolder = Server.MapPath("~/Employee-ReportingPerson/");
//string ExcelFolder = @"D:\HRMS Latest\DSRCManagementSystem\Employee-ReportingPerson";
// @"C:\ShareInventoryReports\ExcelSheets\\";
//Path.GetTempPath();
// string ExcelFolder = @"C:\ShareInventoryReports\ExcelSheets\\";
string FileName = "Employee-Reporting Person.xls";
string destFile = ExcelFolder + FileName;
if (System.IO.File.Exists(sourceFile))
{
if (!Directory.Exists(ExcelFolder))
{
Directory.CreateDirectory(ExcelFolder);
}
System.IO.File.Copy(sourceFile, destFile, true);
FileInfo fileInfo = new FileInfo(destFile);
fileInfo.IsReadOnly = false;
fileInfo.Refresh();
CellDataWriterFirstAndOthers(2, 0, dt, destFile, "Employee-Reporting Person");
}
DataTable dt1 = new DataTable();
AllMail.GetProjectMapping(dt1);
string sourceFile1 = Server.MapPath("~/Template/EmployeeProject-Mapping.xlt");
//string sourceFile1 = Server.MapPath("~/Template/EmployeeProject Mapping.xlt");
// string ExcelFolder1 = Path.GetTempPath();
string ExcelFolder1 = Server.MapPath("~/Employee-ProjectMapping/");
// string ExcelFolder1 = @"D:\HRMS Latest\DSRCManagementSystem\Employee-ProjectMapping";
string FileName1 = "Employee-Project Mapping.xls";
string destFile1 = ExcelFolder1 + FileName1;
if (System.IO.File.Exists(sourceFile1))
{
if (!Directory.Exists(ExcelFolder1))
{
Directory.CreateDirectory(ExcelFolder1);
}
System.IO.File.Copy(sourceFile1, destFile1, true);
FileInfo fileInfo1 = new FileInfo(destFile1);
fileInfo1.IsReadOnly = false;
fileInfo1.Refresh();
CellDataWriterFirstAndOthers(2, 0, dt1, destFile1, "EmployeeProjectMapping");
}
return(View());
}
