public static bool SaveDocumentsType(ATTDocumentsType objDocType) { try { return(DLLDocumentsType.SaveDocumentTypes(objDocType)); } catch (System.Exception ex) { throw ex; } }
public static List <ATTDocumentsType> GetDocumentsType(int?docTypeID) { List <ATTDocumentsType> lstDocumentsType = new List <ATTDocumentsType>(); foreach (DataRow row in DLLDocumentsType.GetDocumentsType(docTypeID).Rows) { ATTDocumentsType obj = new ATTDocumentsType(int.Parse(row["DOC_TYPE_ID"].ToString()), ((row["DOC_TYPE_NAME"] == System.DBNull.Value) ? "" : (string)row["DOC_TYPE_NAME"])); lstDocumentsType.Add(obj); } return(lstDocumentsType); }
public static ObjectValidation Validate(ATTDocumentsType objDocType) { ObjectValidation OV = new ObjectValidation(); if (objDocType.DocTypeName == "") { OV.IsValid = false; OV.ErrorMessage = "Document Type cannot be Blank."; return(OV); } return(OV); }
public static List <ATTDocumentsType> GetDocumentsType(int?docTypeID, bool DTDV) { List <ATTDocumentsType> lstDocumentsType = new List <ATTDocumentsType>(); foreach (DataRow row in DLLDocumentsType.GetDocumentsType(docTypeID).Rows) { ATTDocumentsType obj = new ATTDocumentsType(int.Parse(row["DOC_TYPE_ID"].ToString()), ((row["DOC_TYPE_NAME"] == System.DBNull.Value) ? "" : (string)row["DOC_TYPE_NAME"])); lstDocumentsType.Add(obj); } if (DTDV == true) { lstDocumentsType.Insert(0, new ATTDocumentsType(0, "--- छान्नहोस ---")); } return(lstDocumentsType); }
public static bool SaveDocumentTypes(ATTDocumentsType objDocType) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn().BeginTransaction(); int DocumentTypeID = 0; try { string InsertUpdateSQL = ""; if (objDocType.DocTypeID <= 0) { InsertUpdateSQL = "SP_ADD_DOCUMENTS_TYPE"; } else { InsertUpdateSQL = "SP_EDIT_DOCUMENTS_TYPE"; } OracleParameter[] ParamArray = new OracleParameter[2]; ParamArray[0] = Utilities.GetOraParam(":p_DOC_TYPE_ID", objDocType.DocTypeID, OracleDbType.Int64, ParameterDirection.InputOutput); ParamArray[1] = Utilities.GetOraParam(":p_DOC_TYPE_NAME", objDocType.DocTypeName, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, ParamArray[0], ParamArray); DocumentTypeID = int.Parse(ParamArray[0].Value.ToString()); objDocType.DocTypeID = DocumentTypeID; 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(); } }
protected void btnOK_Click(object sender, EventArgs e) { lblStatusMessage.Text = ""; List <ATTDocumentsType> lstDocumentsType = (List <ATTDocumentsType>)Session["DocumentsType"]; int docTypeID = 0; try { if (this.DocumentsTypeList.SelectedIndex > -1) { docTypeID = lstDocumentsType[this.DocumentsTypeList.SelectedIndex].DocTypeID; } ATTDocumentsType objDocType = new ATTDocumentsType(docTypeID, this.txtDocTypeName_rqd.Text.Trim()); ObjectValidation OV = BLLDocumentsType.Validate(objDocType); if (OV.IsValid == false) { lblStatusMessage.Text = OV.ErrorMessage; this.programmaticModalPopup.Show(); return; } BLLDocumentsType.SaveDocumentsType(objDocType); if (this.DocumentsTypeList.SelectedIndex > -1) { lstDocumentsType[this.DocumentsTypeList.SelectedIndex].DocTypeName = this.txtDocTypeName_rqd.Text.Trim(); } else { objDocType = new ATTDocumentsType(objDocType.DocTypeID, this.txtDocTypeName_rqd.Text.Trim()); lstDocumentsType.Add(objDocType); } this.DocumentsTypeList.DataSource = lstDocumentsType; this.lblStatusMessage.Text = "Successfully Saved"; this.programmaticModalPopup.Show(); this.DocumentsTypeList.DataBind(); this.txtDocTypeName_rqd.Text = ""; this.DocumentsTypeList.SelectedIndex = -1; } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
protected void btnOK_Click(object sender, EventArgs e) { lblStatusMessage.Text = ""; List <ATTDocumentsType> lstDocumentsType = (List <ATTDocumentsType>)Session["DocumentsType"]; int docTypeID = 0; try { if (this.DocumentsTypeList.SelectedIndex > -1) { docTypeID = lstDocumentsType[this.DocumentsTypeList.SelectedIndex].DocTypeID; } ATTDocumentsType objDocType = new ATTDocumentsType(docTypeID, this.txtDocTypeName_rqd.Text.Trim()); ObjectValidation OV = BLLDocumentsType.Validate(objDocType); if (OV.IsValid == false) { lblStatusMessage.Text = OV.ErrorMessage; this.programmaticModalPopup.Show(); return; } bool exists = lstDocumentsType.Exists(delegate(ATTDocumentsType obj) { return(obj.DocTypeName == objDocType.DocTypeName); } ); if (exists) { this.lblStatusMessage.Text = "**सोहि नामको कागजपत्रको विवरण पहिले नै उपलब्द छ"; this.programmaticModalPopup.Show(); this.txtDocTypeName_rqd.Text = ""; this.txtDocTypeName_rqd.Focus(); this.DocumentsTypeList.SelectedIndex = -1; return; } BLLDocumentsType.SaveDocumentsType(objDocType); if (this.DocumentsTypeList.SelectedIndex > -1) { lstDocumentsType[this.DocumentsTypeList.SelectedIndex].DocTypeName = this.txtDocTypeName_rqd.Text.Trim(); } else { objDocType = new ATTDocumentsType(objDocType.DocTypeID, this.txtDocTypeName_rqd.Text.Trim()); lstDocumentsType.Add(objDocType); } this.DocumentsTypeList.DataSource = lstDocumentsType; if (this.DocumentsTypeList.SelectedIndex == -1) { this.lblStatusMessage.Text = "Documents Type Saved Successfully. "; this.programmaticModalPopup.Show(); } else { this.lblStatusMessage.Text = "Documents Type Updated Successfully. "; this.programmaticModalPopup.Show(); } this.DocumentsTypeList.DataBind(); this.txtDocTypeName_rqd.Text = ""; this.txtDocTypeName_rqd.Focus(); this.DocumentsTypeList.SelectedIndex = -1; } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }