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();
}
}
