private ItemCategory_DeliveryDocType objCreateItemCategory_DeliveryDocType(DataRow dr) { ItemCategory_DeliveryDocType tItemCategory_DeliveryDocType = new ItemCategory_DeliveryDocType(); tItemCategory_DeliveryDocType.SetObjectInfo(dr); return(tItemCategory_DeliveryDocType); }
public void UpdateItemCategory_DeliveryDocType(ItemCategory_DeliveryDocType argItemCategory_DeliveryDocType, DataAccess da, List <ErrorHandler> lstErr) { SqlParameter[] param = new SqlParameter[14]; param[0] = new SqlParameter("@DeliveryDocTypeCode", argItemCategory_DeliveryDocType.DeliveryDocTypeCode); param[1] = new SqlParameter("@DeliveryTypeDesc", argItemCategory_DeliveryDocType.DeliveryTypeDesc); param[2] = new SqlParameter("@ItemCatGroupCode", argItemCategory_DeliveryDocType.ItemCatGroupCode); param[3] = new SqlParameter("@HLItemCategoryCode", argItemCategory_DeliveryDocType.HLItemCategoryCode); param[4] = new SqlParameter("@DLItemCategoryCode", argItemCategory_DeliveryDocType.DLItemCategoryCode); param[5] = new SqlParameter("@OptDLItemCategoryCode1", argItemCategory_DeliveryDocType.OptDLItemCategoryCode1); param[6] = new SqlParameter("@OptDLItemCategoryCode2", argItemCategory_DeliveryDocType.OptDLItemCategoryCode2); param[7] = new SqlParameter("@OptDLItemCategoryCode3", argItemCategory_DeliveryDocType.OptDLItemCategoryCode3); param[8] = new SqlParameter("@ClientCode", argItemCategory_DeliveryDocType.ClientCode); param[9] = new SqlParameter("@CreatedBy", argItemCategory_DeliveryDocType.CreatedBy); param[10] = new SqlParameter("@ModifiedBy", argItemCategory_DeliveryDocType.ModifiedBy); param[11] = new SqlParameter("@Type", SqlDbType.Char); param[11].Size = 1; param[11].Direction = ParameterDirection.Output; param[12] = new SqlParameter("@Message", SqlDbType.VarChar); param[12].Size = 255; param[12].Direction = ParameterDirection.Output; param[13] = new SqlParameter("@returnvalue", SqlDbType.VarChar); param[13].Size = 20; param[13].Direction = ParameterDirection.Output; int i = da.NExecuteNonQuery("Proc_UpdateItemCategory_DeliveryDocType", param); string strMessage = Convert.ToString(param[12].Value); string strType = Convert.ToString(param[11].Value); string strRetValue = Convert.ToString(param[13].Value); objErrorHandler.Type = strType; objErrorHandler.MsgId = 0; objErrorHandler.Module = ErrorConstant.strInsertModule; objErrorHandler.ModulePart = ErrorConstant.strMasterModule; objErrorHandler.Message = strMessage.ToString(); objErrorHandler.RowNo = 0; objErrorHandler.FieldName = ""; objErrorHandler.LogCode = ""; lstErr.Add(objErrorHandler); }
public ICollection <ItemCategory_DeliveryDocType> colGetItemCategory_DeliveryDocType(string argClientCode) { List <ItemCategory_DeliveryDocType> lst = new List <ItemCategory_DeliveryDocType>(); DataSet DataSetToFill = new DataSet(); ItemCategory_DeliveryDocType tItemCategory_DeliveryDocType = new ItemCategory_DeliveryDocType(); DataSetToFill = this.GetItemCategory_DeliveryDocType(argClientCode); if (DataSetToFill != null) { foreach (DataRow dr in DataSetToFill.Tables[0].Rows) { lst.Add(objCreateItemCategory_DeliveryDocType(dr)); } } goto Finish; Finish: DataSetToFill = null; return(lst); }
public ItemCategory_DeliveryDocType objGetItemCategory_DeliveryDocType(string argDeliveryDocTypeCode, string argDLItemCategoryCode, string argClientCode) { ItemCategory_DeliveryDocType argItemCategory_DeliveryDocType = new ItemCategory_DeliveryDocType(); DataSet DataSetToFill = new DataSet(); if (argDeliveryDocTypeCode.Trim() == "") { goto ErrorHandlers; } if (argDLItemCategoryCode.Trim() == "") { goto ErrorHandlers; } if (argClientCode.Trim() == "") { goto ErrorHandlers; } DataSetToFill = this.GetItemCategory_DeliveryDocType(argDeliveryDocTypeCode, argDLItemCategoryCode, argClientCode); if (DataSetToFill.Tables[0].Rows.Count <= 0) { goto Finish; } argItemCategory_DeliveryDocType = this.objCreateItemCategory_DeliveryDocType((DataRow)DataSetToFill.Tables[0].Rows[0]); goto Finish; ErrorHandlers: Finish: DataSetToFill = null; return(argItemCategory_DeliveryDocType); }
public ICollection <ItemCategory_DeliveryDocType> colGetItemCategory_DeliveryDocType(DataTable dt, string argUserName, string clientCode) { List <ItemCategory_DeliveryDocType> lst = new List <ItemCategory_DeliveryDocType>(); ItemCategory_DeliveryDocType objItemCategory_DeliveryDocType = null; foreach (DataRow dr in dt.Rows) { objItemCategory_DeliveryDocType = new ItemCategory_DeliveryDocType(); objItemCategory_DeliveryDocType.DeliveryDocTypeCode = Convert.ToString(dr["DeliveryDocTypeCode"]).Trim(); objItemCategory_DeliveryDocType.DeliveryTypeDesc = Convert.ToString(dr["DeliveryTypeDesc"]).Trim(); objItemCategory_DeliveryDocType.ItemCatGroupCode = Convert.ToString(dr["ItemCatGroupCode"]).Trim(); objItemCategory_DeliveryDocType.HLItemCategoryCode = Convert.ToString(dr["HLItemCategoryCode"]).Trim(); objItemCategory_DeliveryDocType.DLItemCategoryCode = Convert.ToString(dr["DLItemCategoryCode"]).Trim(); objItemCategory_DeliveryDocType.OptDLItemCategoryCode1 = Convert.ToString(dr["OptDLItemCategoryCode1"]).Trim(); objItemCategory_DeliveryDocType.OptDLItemCategoryCode2 = Convert.ToString(dr["OptDLItemCategoryCode2"]).Trim(); objItemCategory_DeliveryDocType.OptDLItemCategoryCode3 = Convert.ToString(dr["OptDLItemCategoryCode3"]).Trim(); objItemCategory_DeliveryDocType.IsDeleted = Convert.ToInt32(dr["IsDeleted"]); objItemCategory_DeliveryDocType.ModifiedBy = Convert.ToString(argUserName).Trim(); objItemCategory_DeliveryDocType.CreatedBy = Convert.ToString(argUserName).Trim(); objItemCategory_DeliveryDocType.ClientCode = Convert.ToString(clientCode).Trim(); lst.Add(objItemCategory_DeliveryDocType); } return(lst); }
public ICollection <ErrorHandler> SaveItemCategory_DeliveryDocType(ItemCategory_DeliveryDocType argItemCategory_DeliveryDocType) { List <ErrorHandler> lstErr = new List <ErrorHandler>(); DataAccess da = new DataAccess(); try { if (blnIsItemCategory_DeliveryDocTypeExists(argItemCategory_DeliveryDocType.DeliveryDocTypeCode, argItemCategory_DeliveryDocType.DLItemCategoryCode, argItemCategory_DeliveryDocType.ClientCode) == false) { da.Open_Connection(); da.BEGIN_TRANSACTION(); InsertItemCategory_DeliveryDocType(argItemCategory_DeliveryDocType, da, lstErr); foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } } else { da.Open_Connection(); da.BEGIN_TRANSACTION(); UpdateItemCategory_DeliveryDocType(argItemCategory_DeliveryDocType, da, lstErr); foreach (ErrorHandler objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } } } catch (Exception ex) { if (da != null) { da.ROLLBACK_TRANSACTION(); } objErrorHandler.Type = ErrorConstant.strAboartType; objErrorHandler.MsgId = 0; objErrorHandler.Module = ErrorConstant.strInsertModule; objErrorHandler.ModulePart = ErrorConstant.strMasterModule; objErrorHandler.Message = ex.Message.ToString(); objErrorHandler.RowNo = 0; objErrorHandler.FieldName = ""; objErrorHandler.LogCode = ""; lstErr.Add(objErrorHandler); } finally { if (da != null) { da.Close_Connection(); da = null; } } return(lstErr); }