public List <TypeOfIndustryMasterBO> GetTypeOfIndustryList()
{
DataSet objDataSet = null;
TypeOfIndustryMasterBO objTypeOfIndustryMasterBO = null;
List <TypeOfIndustryMasterBO> objTypeOfIndustryMasterBOList = new List <TypeOfIndustryMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetTypeOfIndustryMasterList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objTypeOfIndustryMasterBO = new TypeOfIndustryMasterBO();
objTypeOfIndustryMasterBO.TypeOfIndustryId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objTypeOfIndustryMasterBO.TypeOfIndustry = objDataSet.Tables[0].Rows[i][1].ToString();
objTypeOfIndustryMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][2].ToString());
objTypeOfIndustryMasterBOList.Add(objTypeOfIndustryMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetTypeOfIndustryList");
throw ex;
}
return(objTypeOfIndustryMasterBOList);
}
public TypeOfIndustryMasterBO EditTypeOfIndustryMaster(int iTypeOfIndustryId)
{
DataSet objDataSet = null;
TypeOfIndustryMasterBO objTypeOfIndustryMasterBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iTypeOfIndustryId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iTypeOfIndustryId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditTypeOfIndustryMaster, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objTypeOfIndustryMasterBO = new TypeOfIndustryMasterBO();
objTypeOfIndustryMasterBO.TypeOfIndustryId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objTypeOfIndustryMasterBO.TypeOfIndustry = objDataSet.Tables[0].Rows[0][1].ToString();
objTypeOfIndustryMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][2].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditTypeOfIndustryMaster");
throw ex;
}
return(objTypeOfIndustryMasterBO);
}
public ActionResult EditTypeOfIndustryMaster(int A_iTypeOfIndustryId)
{
TypeOfIndustryMasterBAL objTypeOfIndustryMasterBAL = new TypeOfIndustryMasterBAL();
TypeOfIndustryMasterBO objTypeOfIndustryMasterBO = objTypeOfIndustryMasterBAL.EditTypeOfIndustryMaster(A_iTypeOfIndustryId);
return(PartialView("AddTypeOfIndustry", objTypeOfIndustryMasterBO));
}
public JsonResult SaveorUpdateTypeOfIndustryMaster(TypeOfIndustryMasterBO Data)
{
TypeOfIndustryMasterBAL objTypeOfIndustryMasterBAL = new TypeOfIndustryMasterBAL();
string strResult = objTypeOfIndustryMasterBAL.SaveorUpdateTypeOfIndustry(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
// GET: TypeOfIndustryMaster
public ActionResult Index()
{
ViewBag.MainTitle = "Security";
ViewBag.Title = "Type Of Industry Master";
ViewBag.Icon = "fa fa-user";
TypeOfIndustryMasterBO objTypeOfIndustryMasterBO = new TypeOfIndustryMasterBO();
return(View());
}
public string SaveorUpdateTypeOfIndustry(TypeOfIndustryMasterBO objTypeOfIndustryMasterBO, int iUserId)
{
return(objTypeOfIndustryMasterDAL.SaveorUpdateTypeOfIndustry(objTypeOfIndustryMasterBO, iUserId));
}
public string SaveorUpdateTypeOfIndustry(TypeOfIndustryMasterBO objTypeOfIndustryMasterBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iTypeOfIndustryId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objTypeOfIndustryMasterBO.TypeOfIndustryId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strTypeOfIndustry";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objTypeOfIndustryMasterBO.TypeOfIndustry;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objTypeOfIndustryMasterBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSaveorUpdateTypeOfIndustry, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveorUpdateTypeOfIndustry");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public ActionResult AddTypeOfIndustryMaster()
{
TypeOfIndustryMasterBO objTypeOfIndustryMasterBO = new TypeOfIndustryMasterBO();
return(PartialView("AddTypeOfIndustry", objTypeOfIndustryMasterBO));
}
