public List <M_ExportSector> getAllExportSector(string status)
{
try
{
List <M_ExportSector> Requests = new List <M_ExportSector>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllExportSectorResult> lst = datacontext._getAllExportSector(status);
foreach (_getAllExportSectorResult result in lst)
{
M_ExportSector req = new M_ExportSector();
req.ExportSectorId = result.ExportId;
req.ExportSectorName = result.ExportSector;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_ExportSector> ExportS_getExportSection(string IsActive)
{
try
{
List <M_ExportSector> lstGroup = new List <M_ExportSector>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getExportSectorResult> lst = datacontext._getExportSector(IsActive);
foreach (_getExportSectorResult result in lst)
{
M_ExportSector grp = new M_ExportSector();
grp.ExportSectorId = Convert.ToInt32(result.ExportId);
grp.ExportSectorName = result.ExportSector;
grp.IsActive = result.Status;
lstGroup.Add(grp);
}
}
return(lstGroup);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public ActionResult NewExportSector(int SD, string IsActive, string Name)
{
M_ExportSector Ex = new M_ExportSector();
if (SD != 0)
{
Ex.IsActive = IsActive;
Ex.ExportSectorId = SD;
Ex.ExportSectorName = Name.Replace("_", " ");
return(PartialView("P_AddEditExportSector", Ex));
}
Ex.IsActive = "Y";
return(PartialView("P_AddEditExportSector", Ex));
}
public JsonResult DeleteExportSector(M_ExportSector Model)
{
string result = "Error";
try
{
if (objSettings.ExportS_DeleteExportSector(Model))
{
result = "Success";
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool ExportS_DeleteExportSector(M_ExportSector sd)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext._setDeleteExportSector(sd.ExportSectorId);
datacontext.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public ActionResult NewExportSector(M_ExportSector Model)
{
if (Model.ExportSectorName == null)
{
Model.IsActive = "Y";
return(PartialView("P_AddEditExportSector", Model));
}
string result = "Error";
try
{
if (Model.ExportSectorId == 0)
{
if (Model.IsActive == null)
{
Model.IsActive = "Y";
}
if (objSettings.ExportS_NewExportSector(Model))
{
result = "Success";
}
}
else
{
if (objSettings.ExportS_UpdateExportSector(Model))
{
result = "Success";
}
}
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
