public ActionResult DeleteConfirmed(int id)
{
CandidateMaster candidateMaster = db.CandidateMasters.Find(id);
db.CandidateMasters.Remove(candidateMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CandidateId,CandidateName,CandidateEmailId,MarketingEmailId,ContactNumber,MarketingNumver,InsertBy,Technology")] CandidateMaster candidateMaster)
{
if (ModelState.IsValid)
{
db.Entry(candidateMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(candidateMaster));
}
// GET: MarketingManager/CandidateManage/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CandidateMaster candidateMaster = db.CandidateMasters.Find(id);
if (candidateMaster == null)
{
return(HttpNotFound());
}
return(View(candidateMaster));
}
public ActionResult Create([Bind(Include = "CandidateId,CandidateName,VisaStatus,CandidateEmailId,MarketingEmailId,ContactNumber,MarketingNumver,InsertBy,Technology,AssignTo")] CandidateMaster candidateMaster)
{
try
{
var users = db.CandidateMasters.OrderByDescending(a => a.CandidateId).ToList();
int id = 1;
if (users.Count > 0)
{
id = users[0].CandidateId + 1;
}
candidateMaster.CandidateId = id;
candidateMaster.InsertBy = Session["name"].ToString();
db.CandidateMasters.Add(candidateMaster);
db.SaveChanges();
TempData["Message"] = "Details Saved!";
}
catch (Exception ex)
{
TempData["Error"] = "Server side Error, Please contact to admin!" + ex.Message;
}
return(RedirectToAction("Index", "CandidateManage", new { @area = "MarketingManager" }));
}
partial void DeleteCandidateMaster(CandidateMaster instance);
partial void UpdateCandidateMaster(CandidateMaster instance);
partial void InsertCandidateMaster(CandidateMaster instance);
public CandidateMasterController()
{
uow = new UnitOfWork();
repo = new CandidateMaster(uow);
}
public JsonResult UploadExcel(CandidateMaster candidates, HttpPostedFileBase FileUpload)
{
List <string> data = new List <string>();
if (FileUpload != null)
{
// tdata.ExecuteCommand("truncate table OtherCompanyAssets");
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = FileUpload.FileName;
string targetpath = Server.MapPath("~/Doc/");
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var connectionString = "";
if (filename.EndsWith(".xls"))
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);
}
else if (filename.EndsWith(".xlsx"))
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);
}
var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "ExcelTable");
DataTable dtable = ds.Tables["ExcelTable"];
string sheetName = "Sheet1";
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var candidatesExcel = from a in excelFile.Worksheet <CandidateMaster>(sheetName) select a;
foreach (var a in candidatesExcel)
{
try
{
if (a.CandidateId != 0 && a.CandidateName != "")
{
CandidateMaster CAN = new CandidateMaster();
CAN.CandidateId = a.CandidateId;
CAN.CandidateName = a.CandidateName;
CAN.CandidateEmailId = a.CandidateEmailId;
CAN.MarketingEmailId = a.MarketingEmailId;
CAN.ContactNumber = a.ContactNumber;
CAN.MarketingNumver = a.MarketingNumver;
CAN.InsertBy = a.InsertBy;
CAN.Technology = a.Technology;
CAN.AssignTo = a.AssignTo;
CAN.VisaStatus = a.VisaStatus;
db.CandidateMasters.Add(CAN);
db.SaveChanges();
}
else
{
data.Add("<ul>");
if (a.CandidateId == 0)
{
data.Add("<li> ID is required</li>");
}
if (a.CandidateName == null)
{
data.Add("<li> NAME is required</li>");
}
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
//deleting excel file from folder
if ((System.IO.File.Exists(pathToExcelFile)))
{
System.IO.File.Delete(pathToExcelFile);
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
else
{
//alert message for invalid file format
data.Add("<ul>");
data.Add("<li>Only Excel file format is allowed</li>");
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
else
{
data.Add("<ul>");
if (FileUpload == null)
{
data.Add("<li>Please choose Excel file</li>");
}
data.Add("</ul>");
data.ToArray();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
