public static List <ATTDocumentType> GetDocumentType(int?DocumentType, string active, int defaultFlag) { List <ATTDocumentType> DocumentTypeList = new List <ATTDocumentType>(); try { foreach (DataRow row in DLLDocumentType.GetDocumentType(DocumentType, active).Rows) { ATTDocumentType Reglst = new ATTDocumentType( int.Parse(row["DOCUMENT_TYPE_ID"].ToString()), row["DOCUMENT_TYPE_NAME"].ToString(), row["ACTIVE"].ToString()); DocumentTypeList.Add(Reglst); } if (defaultFlag > 0) { DocumentTypeList.Insert(0, new ATTDocumentType(0, "छान्नुहोस", "")); } return(DocumentTypeList); } catch (Exception ex) { throw ex; } }
public static bool SaveDocumentType(ATTDocumentType objDocumentType) { try { return(DLLDocumentType.SaveDocumentType(objDocumentType)); } catch (Exception ex) { throw ex; } }
public static bool SaveDocumentType(ATTDocumentType objDocumentType) { string InsertUpdateSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_DOCUMENT_TYPE_ID", objDocumentType.DocumentTypeID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_DOCUMENT_TYPE_NAME", objDocumentType.DocumentTypeName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objDocumentType.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objDocumentType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (objDocumentType.Action == "A") { InsertUpdateSQL = "SP_ADD_DOCUMENT_TYPE_CASE"; } else if (objDocumentType.Action == "E") { InsertUpdateSQL = "SP_EDIT_DOCUMENT_TYPE_CASE"; } GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); objDocumentType.DocumentTypeID = int.Parse(paramArray[0].Value.ToString()); Tran.Commit(); return(true); } catch (OracleException oex) { PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }