private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; try { strSQL = "SELECT MST_INVOICE_SERIES.INVOICE_SERIES_ID AS INVOICE_SERIES_ID," + " MST_COMPANY.COMPANY_ID AS COMPANY_ID," + " MST_COMPANY.COMPANY_NAME AS COMPANY_NAME," + " MST_INVOICE_SERIES.PREFIX AS PREFIX," + " MST_INVOICE_SERIES.START_NO AS START_NO," + " MST_INVOICE_SERIES.LAST_NO AS LAST_NO," + " " + cmnService.J_SQLDBFormat("MST_INVOICE_SERIES.LAST_DATE", J_SQLColFormat.DateFormatDDMMYYYY) + " AS LAST_DATE," + " MST_INVOICE_SERIES.HEADER_DISPLAY_TEXT AS HEADER_DISPLAY_TEXT" + " FROM MST_INVOICE_SERIES," + " MST_COMPANY" + " WHERE MST_INVOICE_SERIES.COMPANY_ID = MST_COMPANY.COMPANY_ID " + " AND MST_INVOICE_SERIES.BRANCH_ID = " + J_Var.J_pBranchId + " " + " AND MST_INVOICE_SERIES.INVOICE_SERIES_ID = " + Id + " "; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; cmbCompanyName.Text = Convert.ToString(drdShowRecord["COMPANY_NAME"]); txtPrefix.Text = Convert.ToString(drdShowRecord["PREFIX"]); txtStartNo.Text = Convert.ToString(drdShowRecord["START_NO"]); //txtLastNo.Text = Convert.ToInt32(drdShowRecord["LAST_NO"]); mskLastDate.Text = Convert.ToString(drdShowRecord["LAST_DATE"]); txtDisplayText.Text = Convert.ToString(drdShowRecord["HEADER_DISPLAY_TEXT"]); drdShowRecord.Close(); drdShowRecord.Dispose(); cmbCompanyName.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; try { strSQL = "SELECT TAX_ID AS TAX_ID," + " TAX_DESC AS TAX_DESC," + " TAX_RATE AS TAX_RATE" + " FROM MST_TAX" + " WHERE BRANCH_ID = " + J_Var.J_pBranchId + " AND TAX_ID = " + lngSearchId; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; txtTaxDesc.Text = Convert.ToString(drdShowRecord["TAX_DESC"]); txtTaxPercentage.Text = string.Format("{0:0.00}", Convert.ToDouble(Convert.ToString(drdShowRecord["TAX_RATE"]) == "" ? "0.00" : Convert.ToString(drdShowRecord["TAX_RATE"]))); drdShowRecord.Close(); drdShowRecord.Dispose(); txtTaxDesc.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord() { IDataReader drdShowRecord = null; try { strSQL = "SELECT " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_ID", J_ColumnType.Integer, J_SQLColFormat.NullCheck) + " AS BRANCH_ID," + " " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_CODE", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS BRANCH_CODE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS BRANCH_NAME," + " " + cmnService.J_SQLDBFormat("MST_SETUP.COMPANY_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS COMPANY_NAME," + " " + cmnService.J_SQLDBFormat("MST_SETUP.ADDRESS", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS ADDRESS," + " " + cmnService.J_SQLDBFormat("MST_SETUP.CITY", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS CITY," + " " + cmnService.J_SQLDBFormat("MST_SETUP.PIN", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS PIN," + " " + cmnService.J_SQLDBFormat("MST_SETUP.CONTACT_NO", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS CONTACT_NO," + " " + cmnService.J_SQLDBFormat("MST_SETUP.EMAIL_ID", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS EMAIL_ID," + " " + cmnService.J_SQLDBFormat("MST_SETUP.WEB_SITE", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS WEB_SITE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.START_DATE", J_ColumnType.Date, J_SQLColFormat.DateFormatDDMMYYYY) + " AS START_DATE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.OPENING_SUNDRY_OUTSTANDING", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS OPENING_SUNDRY_OUTSTANDING," + " " + cmnService.J_SQLDBFormat("MST_SETUP.SUNDRY_CUTOFF_DATE", J_ColumnType.Date, J_SQLColFormat.DateFormatDDMMYYYY) + " AS SUNDRY_CUTOFF_DATE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.SAVE_CONFIRMATION_MSG", J_ColumnType.Integer, J_SQLColFormat.NullCheck) + " AS SAVE_CONFIRMATION_MSG," + " " + cmnService.J_SQLDBFormat("MST_SETUP.LAST_RECONCILIATION_DATE", J_ColumnType.Date, J_SQLColFormat.DateFormatDDMMYYYY) + " AS LAST_RECONCILIATION_DATE," + " NETWORK_CREDENTIAL_USERNAME AS USERNAME," + " NETWORK_CREDENTIAL_PASSWORD AS PASSWORD," + " NETWORK_CREDENTIAL_PORT AS PORT," + " NETWORK_CREDENTIAL_HOST AS HOST, " + " SMS_WORKING_KEY AS SMS_WORKING_KEY, " + " SMS_OFFLINE_INVOICE_MESSAGE AS SMS_OFFLINE_INVOICE_MESSAGE, " + " SMS_ONLINE_INVOICE_MESSAGE AS SMS_ONLINE_INVOICE_MESSAGE, " + " SMS_SENDER_NAME AS SMS_SENDER_NAME " + "FROM MST_SETUP " + "WHERE MST_SETUP.BRANCH_ID = " + J_Var.J_pBranchId + " "; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } // variable declaration & initialization int intTentativeDisbursementDays = 0; double dblPreClosurePenaltyPer = 0; while (drdShowRecord.Read()) { txtBranchCode.Text = Convert.ToString(drdShowRecord["BRANCH_CODE"]); txtBranchName.Text = Convert.ToString(drdShowRecord["BRANCH_NAME"]); txtCompanyName.Text = Convert.ToString(drdShowRecord["COMPANY_NAME"]); txtAddress.Text = Convert.ToString(drdShowRecord["ADDRESS"]); txtCity.Text = Convert.ToString(drdShowRecord["CITY"]); txtPin.Text = Convert.ToString(drdShowRecord["PIN"]); txtContactNo.Text = Convert.ToString(drdShowRecord["CONTACT_NO"]); txtEmailId.Text = Convert.ToString(drdShowRecord["EMAIL_ID"]); txtWebsite.Text = Convert.ToString(drdShowRecord["WEB_SITE"]); mskStartDate.Text = Convert.ToString(drdShowRecord["START_DATE"]); txtSundryOpening.Text = string.Format("{0:0.00}", Convert.ToDouble(drdShowRecord["OPENING_SUNDRY_OUTSTANDING"])); mskSundryCutoffDate.Text = Convert.ToString(drdShowRecord["SUNDRY_CUTOFF_DATE"]); // txtNetUsername.Text = Convert.ToString(drdShowRecord["USERNAME"]); txtNetPassword.Text = Convert.ToString(drdShowRecord["PASSWORD"]); txtNetPort.Text = Convert.ToString(drdShowRecord["PORT"]); txtNetHost.Text = Convert.ToString(drdShowRecord["HOST"]); // txtSmsWorkingKey.Text = Convert.ToString(drdShowRecord["SMS_WORKING_KEY"]); txtOfflineSmsMessage.Text = Convert.ToString(drdShowRecord["SMS_OFFLINE_INVOICE_MESSAGE"]); txtOnlineSmsMessage.Text = Convert.ToString(drdShowRecord["SMS_ONLINE_INVOICE_MESSAGE"]); txtSmsSenderName.Text = Convert.ToString(drdShowRecord["SMS_SENDER_NAME"]); if (Convert.ToInt32(Convert.ToString(drdShowRecord["SAVE_CONFIRMATION_MSG"])) == 0) { chkSaveConfirmationMessage.Checked = false; } else if (Convert.ToInt32(Convert.ToString(drdShowRecord["SAVE_CONFIRMATION_MSG"])) == 1) { chkSaveConfirmationMessage.Checked = true; } mskLastReconcileDate.Text = Convert.ToString(drdShowRecord["LAST_RECONCILIATION_DATE"]); J_Var.J_pBranchId = Convert.ToInt32(Convert.ToString(drdShowRecord["BRANCH_ID"])); J_Var.J_pBranchCode = Convert.ToString(drdShowRecord["BRANCH_CODE"]); J_Var.J_pBranchName = Convert.ToString(drdShowRecord["BRANCH_NAME"]); J_Var.J_pCompanyName = Convert.ToString(drdShowRecord["COMPANY_NAME"]); J_Var.J_pBranchAddress = Convert.ToString(drdShowRecord["ADDRESS"]); J_Var.J_pSoftwareStartDate = Convert.ToString(drdShowRecord["START_DATE"]); J_Var.J_pSaveConfirmMsg = Convert.ToInt32(Convert.ToString(drdShowRecord["SAVE_CONFIRMATION_MSG"])); // J_Var.J_pNetworkCredential_Username = Convert.ToString(drdShowRecord["USERNAME"]); J_Var.J_pNetworkCredential_Password = Convert.ToString(drdShowRecord["PASSWORD"]); J_Var.J_pNetworkCredential_Port = Convert.ToString(drdShowRecord["PORT"]); J_Var.J_pNetworkCredential_Host = Convert.ToString(drdShowRecord["HOST"]); //-- J_Var.J_pSMS_WorkingKey = Convert.ToString(drdShowRecord["SMS_WORKING_KEY"]); J_Var.J_pOfflineInvoiceSMS_Text = Convert.ToString(drdShowRecord["SMS_OFFLINE_INVOICE_MESSAGE"]); J_Var.J_pOnlineInvoiceSMS_Text = Convert.ToString(drdShowRecord["SMS_ONLINE_INVOICE_MESSAGE"]); J_Var.J_pSMS_SenderName = Convert.ToString(drdShowRecord["SMS_SENDER_NAME"]); //-- J_Var.J_pLastReconcileDate = Convert.ToString(drdShowRecord["LAST_RECONCILIATION_DATE"]); // reader object is closed & also disposed drdShowRecord.Close(); drdShowRecord.Dispose(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private void BtnOK_Click(object sender, EventArgs e) { try { // Check the Validation if (ValidateFields() == false) { return; } // Make the query string for Company Information strSQL = "SELECT " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_ID", J_ColumnType.Integer, J_SQLColFormat.NullCheck) + " AS BRANCH_ID," + " " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_CODE", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS BRANCH_CODE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.BRANCH_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS BRANCH_NAME," + " " + cmnService.J_SQLDBFormat("MST_SETUP.COMPANY_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS COMPANY_NAME," + " " + cmnService.J_SQLDBFormat("MST_SETUP.ADDRESS", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS ADDRESS," + " " + cmnService.J_SQLDBFormat("MST_SETUP.START_DATE", J_ColumnType.Date, J_SQLColFormat.DateFormatDDMMYYYY) + " AS START_DATE," + " " + cmnService.J_SQLDBFormat("MST_SETUP.SAVE_CONFIRMATION_MSG", J_ColumnType.Integer, J_SQLColFormat.NullCheck) + " AS SAVE_CONFIRMATION_MSG," + " " + cmnService.J_SQLDBFormat("MST_SETUP.NETWORK_CREDENTIAL_USERNAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS NETWORK_CREDENTIAL_USERNAME," + " " + cmnService.J_SQLDBFormat("MST_SETUP.NETWORK_CREDENTIAL_PASSWORD", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS NETWORK_CREDENTIAL_PASSWORD," + " " + cmnService.J_SQLDBFormat("MST_SETUP.NETWORK_CREDENTIAL_PORT", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS NETWORK_CREDENTIAL_PORT," + " " + cmnService.J_SQLDBFormat("MST_SETUP.NETWORK_CREDENTIAL_HOST", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS NETWORK_CREDENTIAL_HOST, " + " " + cmnService.J_SQLDBFormat("MST_SETUP.SMS_WORKING_KEY", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS SMS_WORKING_KEY, " + " " + cmnService.J_SQLDBFormat("MST_SETUP.SMS_OFFLINE_INVOICE_MESSAGE", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS SMS_OFFLINE_INVOICE_MESSAGE, " + " " + cmnService.J_SQLDBFormat("MST_SETUP.SMS_ONLINE_INVOICE_MESSAGE", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS SMS_ONLINE_INVOICE_MESSAGE, " + " " + cmnService.J_SQLDBFormat("MST_SETUP.SMS_SENDER_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + " AS SMS_SENDER_NAME " + "FROM MST_SETUP " + "WHERE MST_SETUP.BRANCH_ID = " + J_Var.J_pBranchId + ""; // return the data reader as per above query string this.reader = dmlService.J_ExecSqlReturnReader(strSQL); // check the given reader is null if (reader == null) { cmbLoginId.Select(); return; } // fetch the data from reader while (reader.Read()) { J_Var.J_pBranchId = Convert.ToInt32(Convert.ToString(reader["BRANCH_ID"])); J_Var.J_pBranchCode = Convert.ToString(reader["BRANCH_CODE"]); J_Var.J_pBranchName = Convert.ToString(reader["BRANCH_NAME"]); J_Var.J_pCompanyName = Convert.ToString(reader["COMPANY_NAME"]); J_Var.J_pBranchAddress = Convert.ToString(reader["ADDRESS"]); J_Var.J_pSoftwareStartDate = Convert.ToString(reader["START_DATE"]); J_Var.J_pSaveConfirmMsg = Convert.ToInt32(Convert.ToString(reader["SAVE_CONFIRMATION_MSG"])); //ADDED BY DHRUB ON 31/01/2015 FOR SEND EMAIL AGAINST IVOICE J_Var.J_pNetworkCredential_Username = Convert.ToString(Convert.ToString(reader["NETWORK_CREDENTIAL_USERNAME"])); J_Var.J_pNetworkCredential_Password = Convert.ToString(Convert.ToString(reader["NETWORK_CREDENTIAL_PASSWORD"])); J_Var.J_pNetworkCredential_Port = Convert.ToString(Convert.ToString(reader["NETWORK_CREDENTIAL_PORT"])); J_Var.J_pNetworkCredential_Host = Convert.ToString(Convert.ToString(reader["NETWORK_CREDENTIAL_HOST"])); //ADDED BY DHRUB ON 31/01/2015 FOR SEND EMAIL AGAINST IVOICE J_Var.J_pSMS_WorkingKey = Convert.ToString(Convert.ToString(reader["SMS_WORKING_KEY"])); J_Var.J_pOfflineInvoiceSMS_Text = Convert.ToString(Convert.ToString(reader["SMS_OFFLINE_INVOICE_MESSAGE"])); J_Var.J_pOnlineInvoiceSMS_Text = Convert.ToString(Convert.ToString(reader["SMS_ONLINE_INVOICE_MESSAGE"])); J_Var.J_pSMS_SenderName = Convert.ToString(Convert.ToString(reader["SMS_SENDER_NAME"])); } // reader is closed & disposed this.reader.Close(); this.reader.Dispose(); // Make the query string strSQL = "SELECT USER_ID," + " DISPLAY_NAME," + " USER_CATEGORY " + "FROM MST_USER " + "WHERE " + cmnService.J_SQLDBFormat("LOGIN_ID", J_SQLColFormat.UCase) + " = '" + cmnService.J_ReplaceQuote(cmbLoginId.Text.ToUpper().Trim()) + "' " + "AND USER_PASSWORD = '******' "; if (cmbLoginId.Text.ToUpper() != "ADMIN") { strSQL = strSQL + "AND BRANCH_ID = " + J_Var.J_pBranchId + " "; } // return the dataset as per above query string DataSet ds = dmlService.J_ExecSqlReturnDataSet(strSQL); // check the given dataset is null if (ds == null) { cmbLoginId.Select(); return; } if (ds.Tables[0].Rows.Count > 0) { J_Var.J_pUserId = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[0][0])); J_Var.J_pLoginId = cmnService.J_ReplaceQuote(cmbLoginId.Text.ToUpper().Trim()); J_Var.J_pUserDisplayName = Convert.ToString(ds.Tables[0].Rows[0][1]); J_Var.J_pUserCategory = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[0][2])); // Close & Dispose the MstLogin Class dmlService.Dispose(); this.Close(); this.Dispose(); if (J_Var.J_pLoginStatus == 1) { J_Var.frmMain.Close(); J_Var.frmMain.Dispose(); } Hashtable nameValue = new Hashtable(); nameValue.Add("BRANCHINFO", J_Var.J_pBranchCode); XMLService objxml = new XMLService(); objxml.J_CreateXMLFile(nameValue, Application.StartupPath + "/" + J_Var.J_pXmlBranchInfoFileName, "BRANCHINFO"); // Create object of MDI Class J_Var.frmMain = new mdiBillingSystem(); J_Var.frmMain.ShowDialog(); } else { cmbLoginId.Select(); } } catch (Exception err_handler) { this.reader.Close(); this.reader.Dispose(); cmnService.J_UserMessage(err_handler.Message); cmbLoginId.Select(); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; string strStateName = string.Empty; string strDistrictName = string.Empty; try { strSQL = "SELECT MST_PARTY.PARTY_ID AS PARTY_ID," + " MST_PARTY_CATEGORY.PARTY_CATEGORY_DESCRIPTION AS PARTY_CATEGORY_DESCRIPTION," + " MST_PARTY.PARTY_NAME AS PARTY_NAME," + " MST_PARTY.ADDRESS1 AS ADDRESS1," + " MST_PARTY.ADDRESS2 AS ADDRESS2," + " MST_PARTY.ADDRESS3 AS ADDRESS3," + " MST_PARTY.CITY AS CITY," + " MST_PARTY.PIN AS PIN," + " MST_PARTY.CONTACT_PERSON AS CONTACT_PERSON," + " MST_PARTY.MOBILE_NO AS MOBILE_NO," + " MST_PARTY.PHONE_NO AS PHONE_NO," + " MST_PARTY.FAX AS FAX," + " MST_PARTY.EMAIL_ID AS EMAIL_ID, " + " MST_PARTY.VAT_NO AS VAT_NO " + " FROM MST_PARTY, " + " MST_PARTY_CATEGORY " + " WHERE MST_PARTY.PARTY_CATEGORY_ID = MST_PARTY_CATEGORY.PARTY_CATEGORY_ID " + " AND MST_PARTY.BRANCH_ID = " + J_Var.J_pBranchId + " " + " AND MST_PARTY.PARTY_ID = " + Id + " "; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; txtPartyName.Text = Convert.ToString(drdShowRecord["PARTY_NAME"]); txtAddress1.Text = Convert.ToString(drdShowRecord["ADDRESS1"]); txtAddress2.Text = Convert.ToString(drdShowRecord["ADDRESS2"]); txtAddress3.Text = Convert.ToString(drdShowRecord["ADDRESS3"]); txtCity.Text = Convert.ToString(drdShowRecord["CITY"]); txtPin.Text = Convert.ToString(drdShowRecord["PIN"]); txtContactPersonName.Text = Convert.ToString(drdShowRecord["CONTACT_PERSON"]); txtMobileNo.Text = Convert.ToString(drdShowRecord["MOBILE_NO"]); txtPhone.Text = Convert.ToString(drdShowRecord["PHONE_NO"]); txtFaxNo.Text = Convert.ToString(drdShowRecord["FAX"]); txtEmailID.Text = Convert.ToString(drdShowRecord["EMAIL_ID"]); txtVatNo.Text = Convert.ToString(drdShowRecord["VAT_NO"]); cmbPartyCategory.Text = Convert.ToString(drdShowRecord["PARTY_CATEGORY_DESCRIPTION"]); drdShowRecord.Close(); drdShowRecord.Dispose(); txtPartyName.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; IDataReader reader = null; try { // SQL Query strSQL = @"SELECT TRN_INVOICE_HEADER.INVOICE_HEADER_ID AS INVOICE_HEADER_ID, TRN_INVOICE_HEADER.INVOICE_NO AS INVOICE_NO, " + cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.INVOICE_DATE", J_SQLColFormat.DateFormatDDMMYYYY) + @" AS INVOICE_DATE, " + cmnService.J_SQLDBFormat("MST_PARTY.PARTY_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + @" AS PARTY_NAME, " + cmnService.J_SQLDBFormat("MST_PARTY.PARTY_ID", J_ColumnType.Long, J_SQLColFormat.NullCheck) + @" AS PARTY_ID, MST_PARTY_CATEGORY.PARTY_CATEGORY_DESCRIPTION AS PARTY_CATEGORY_DESCRIPTION, TRN_INVOICE_HEADER.NET_AMOUNT AS NET_AMOUNT, MST_PAYMENT_TYPE.PAYMENT_TYPE_DESCRIPTION AS PAYMENT_TYPE_DESCRIPTION, MST_BANK.BANK_NAME AS BANK_NAME, TRN_INVOICE_HEADER.REFERENCE_NO AS REFERENCE_NO, " + cmnService.J_SQLDBFormat(cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.ACCOUNT_ENTRY_DATE", J_SQLColFormat.DateFormatDDMMYYYY), J_ColumnType.String, J_SQLColFormat.NullCheck) + @" AS ACCOUNT_ENTRY_DATE, " + cmnService.J_SQLDBFormat(cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.BANK_STATEMENT_DATE", J_SQLColFormat.DateFormatDDMMYYYY), J_ColumnType.String, J_SQLColFormat.NullCheck) + @" AS BANK_STATEMENT_DATE, DELIVERY_MODE_ID FROM ((((TRN_INVOICE_HEADER LEFT JOIN MST_PARTY ON TRN_INVOICE_HEADER.PARTY_ID = MST_PARTY.PARTY_ID) LEFT JOIN MST_PARTY_CATEGORY ON MST_PARTY.PARTY_CATEGORY_ID = MST_PARTY_CATEGORY.PARTY_CATEGORY_ID) LEFT JOIN MST_PAYMENT_TYPE ON TRN_INVOICE_HEADER.PAYMENT_TYPE_ID = MST_PAYMENT_TYPE.PAYMENT_TYPE_ID) LEFT JOIN MST_BANK ON TRN_INVOICE_HEADER.BANK_ID = MST_BANK.BANK_ID) WHERE TRN_INVOICE_HEADER.INVOICE_HEADER_ID = " + Id; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; mskAccountEntryDate.Text = Convert.ToString(drdShowRecord["ACCOUNT_ENTRY_DATE"]); mskBankDate.Text = Convert.ToString(drdShowRecord["BANK_STATEMENT_DATE"]); lngPartyId = Convert.ToInt64(drdShowRecord["PARTY_ID"].ToString()); lblInvoiceNo.Text = drdShowRecord["INVOICE_NO"].ToString(); lblInvoiceDate.Text = drdShowRecord["INVOICE_DATE"].ToString(); lblPartyName.Text = drdShowRecord["PARTY_NAME"].ToString(); cmbPartyCategory.Text = drdShowRecord["PARTY_CATEGORY_DESCRIPTION"].ToString(); lblAmount.Text = string.Format("{0:0.00}", Convert.ToDouble(drdShowRecord["NET_AMOUNT"].ToString())); cmbPaymentType.Text = drdShowRecord["PAYMENT_TYPE_DESCRIPTION"].ToString(); cmbBank.Text = drdShowRecord["BANK_NAME"].ToString(); txtReference.Text = drdShowRecord["REFERENCE_NO"].ToString(); // if (lngPartyId == 0) { cmbPartyCategory.Visible = false; lblPartyCategory.Visible = false; } else { cmbPartyCategory.Visible = true; lblPartyCategory.Visible = true; } // if (drdShowRecord["DELIVERY_MODE_ID"].ToString() == "1") { cmbPartyCategory.Enabled = false; cmbPaymentType.Enabled = false; txtReference.Enabled = false; cmbBank.Enabled = false; } else { cmbPartyCategory.Enabled = true; cmbPaymentType.Enabled = true; txtReference.Enabled = true; cmbBank.Enabled = true; } drdShowRecord.Close(); drdShowRecord.Dispose(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(J_Msg.RecNotExist); if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; string strStateName = string.Empty; string strDistrictName = string.Empty; try { strSQL = "SELECT COMPANY_ID AS COMPANY_ID," + " COMPANY_NAME AS COMPANY_NAME," + " ADDRESS1 AS ADDRESS1," + " ADDRESS2 AS ADDRESS2," + " ADDRESS3 AS ADDRESS3," + " CITY AS CITY," + " PIN AS PIN," + " CONTACT_NO AS CONTACT_NO," + " FAX AS FAX," + " EMAIL_ID AS EMAIL_ID," + " WEB_SITE AS WEB_SITE," + " CONTACT_PERSON AS CONTACT_PERSON," + " SIGNATORY AS SIGNATORY," + " VAT_NO AS VAT_NO," + " CST_NO AS CST_NO," + " SERVICE_TAX_NO AS SERVICE_TAX_NO," + " PAN AS PAN, " + " CIN_NO AS CIN_NO, " + " MAX_DAYS_PERMIT AS MAX_DAYS_PERMIT," + " BANK_DETAIL1 AS BANK_DETAIL1," + //-- 2016/02/18 ANIK " BANK_DETAIL2 AS BANK_DETAIL2," + " BANK_DETAIL3 AS BANK_DETAIL3," + " BANK_DETAIL4 AS BANK_DETAIL4," + " BANK_DETAIL5 AS BANK_DETAIL5 " + " FROM MST_COMPANY" + " WHERE MST_COMPANY.BRANCH_ID = " + J_Var.J_pBranchId + " " + " AND MST_COMPANY.COMPANY_ID = " + Id + " "; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; txtCompanyName.Text = Convert.ToString(drdShowRecord["COMPANY_NAME"]); txtAddress1.Text = Convert.ToString(drdShowRecord["ADDRESS1"]); txtAddress2.Text = Convert.ToString(drdShowRecord["ADDRESS2"]); txtAddress3.Text = Convert.ToString(drdShowRecord["ADDRESS3"]); txtCity.Text = Convert.ToString(drdShowRecord["CITY"]); txtPin.Text = Convert.ToString(drdShowRecord["PIN"]); txtContactNo.Text = Convert.ToString(drdShowRecord["CONTACT_NO"]); txtFax.Text = Convert.ToString(drdShowRecord["FAX"]); txtEmailID.Text = Convert.ToString(drdShowRecord["EMAIL_ID"]); txtWebsite.Text = Convert.ToString(drdShowRecord["WEB_SITE"]); txtContactPersonName.Text = Convert.ToString(drdShowRecord["CONTACT_PERSON"]); txtSignatory.Text = Convert.ToString(drdShowRecord["SIGNATORY"]); txtVATNo.Text = Convert.ToString(drdShowRecord["VAT_NO"]); txtCSTNo.Text = Convert.ToString(drdShowRecord["CST_NO"]); txtServiceTaxNo.Text = Convert.ToString(drdShowRecord["SERVICE_TAX_NO"]); txtPAN.Text = Convert.ToString(drdShowRecord["PAN"]); txtCINNo.Text = Convert.ToString(drdShowRecord["CIN_NO"]); txtMaxPermitedDays.Text = Convert.ToString(drdShowRecord["MAX_DAYS_PERMIT"]); //-- 2016/02/18 ANIK txtBankDetails1.Text = Convert.ToString(drdShowRecord["BANK_DETAIL1"]); txtBankDetails2.Text = Convert.ToString(drdShowRecord["BANK_DETAIL2"]);; txtBankDetails3.Text = Convert.ToString(drdShowRecord["BANK_DETAIL3"]);; txtBankDetails4.Text = Convert.ToString(drdShowRecord["BANK_DETAIL4"]);; txtBankDetails5.Text = Convert.ToString(drdShowRecord["BANK_DETAIL5"]);; drdShowRecord.Close(); drdShowRecord.Dispose(); txtCompanyName.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; try { // SQL Query strSQL = @"SELECT TRN_INVOICE_HEADER.INVOICE_HEADER_ID AS INVOICE_HEADER_ID, " + cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.INVOICE_DATE", J_SQLColFormat.DateFormatDDMMYYYY) + @" AS INVOICE_DATE, " + cmnService.J_SQLDBFormat("MST_PARTY.PARTY_NAME", J_ColumnType.String, J_SQLColFormat.NullCheck) + @" AS PARTY_NAME, TRN_INVOICE_HEADER.NET_AMOUNT AS NET_AMOUNT, MST_PAYMENT_TYPE.PAYMENT_TYPE_DESCRIPTION AS PAYMENT_TYPE_DESCRIPTION, MST_BANK.BANK_NAME AS BANK_NAME, TRN_INVOICE_HEADER.REFERENCE_NO AS REFERENCE_NO, TRN_INVOICE_HEADER.REMARKS AS REMARKS, " + cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.ACCOUNT_ENTRY_DATE", J_SQLColFormat.DateFormatDDMMYYYY) + @" AS ACCOUNT_ENTRY_DATE, " + cmnService.J_SQLDBFormat("TRN_INVOICE_HEADER.BANK_STATEMENT_DATE", J_SQLColFormat.DateFormatDDMMYYYY) + @" AS BANK_STATEMENT_DATE, TRN_INVOICE_HEADER.CANCELLATION_FLAG AS CANCELLATION_FLAG FROM (((TRN_INVOICE_HEADER LEFT JOIN MST_PARTY ON TRN_INVOICE_HEADER.PARTY_ID = MST_PARTY.PARTY_ID) LEFT JOIN MST_PAYMENT_TYPE ON TRN_INVOICE_HEADER.PAYMENT_TYPE_ID = MST_PAYMENT_TYPE.PAYMENT_TYPE_ID) LEFT JOIN MST_BANK ON TRN_INVOICE_HEADER.BANK_ID = MST_BANK.BANK_ID) WHERE TRN_INVOICE_HEADER.INVOICE_HEADER_ID = " + Id; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; mskInvoiceDate.Text = drdShowRecord["INVOICE_DATE"].ToString(); mskAccountEntryDate.Text = drdShowRecord["ACCOUNT_ENTRY_DATE"].ToString(); mskBankDate.Text = drdShowRecord["BANK_STATEMENT_DATE"].ToString(); cmbPaymentType.Text = drdShowRecord["PAYMENT_TYPE_DESCRIPTION"].ToString(); cmbBank.Text = drdShowRecord["BANK_NAME"].ToString(); txtReference.Text = drdShowRecord["REFERENCE_NO"].ToString(); txtAmount.Text = string.Format("{0:0.00}", Convert.ToDouble(drdShowRecord["NET_AMOUNT"].ToString())); txtRemarks.Text = drdShowRecord["REMARKS"].ToString(); if (drdShowRecord["CANCELLATION_FLAG"].ToString() == "1") { chkCancelled.Checked = true; } else { chkCancelled.Checked = false; } drdShowRecord.Close(); drdShowRecord.Dispose(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(J_Msg.RecNotExist); if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; try { // SQL Query strSQL = "SELECT DISPLAY_NAME," + " LOGIN_ID," + " USER_CATEGORY " + "FROM MST_USER " + "WHERE USER_ID = " + Id + ""; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; txtUserName.Text = drdShowRecord["DISPLAY_NAME"].ToString(); txtLoginId.Text = drdShowRecord["LOGIN_ID"].ToString(); if (Convert.ToInt32(drdShowRecord["USER_CATEGORY"].ToString()) == 0) { chkActiveInactive.Checked = true; } else { chkActiveInactive.Checked = false; } drdShowRecord.Close(); drdShowRecord.Dispose(); txtUserName.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(J_Msg.RecNotExist); lngSearchId = 0; if (strCheckFields == "") { strSQL = strQuery + "order by " + strOrderBy; } else { strSQL = strQuery + strCheckFields + "order by " + strOrderBy; } if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }
private bool ShowRecord(long Id) { IDataReader drdShowRecord = null; try { // SQL Query strSQL = "SELECT EMAIL_SUBJECT_ONLINE," + " EMAIL_SUBJECT_OFFLINE," + " EMAIL_SUBJECT_DESPATCH," + " EMAIL_BODY_ONLINE," + " EMAIL_BODY_OFFLINE," + " EMAIL_BODY_DESPATCH," + " FROM_EMAIL," + " DISPLAY_NAME," + " EMAIL_BCC," + " INACTIVE_FLAG " + "FROM MST_EMAIL_CATEGORY " + "WHERE EMAIL_TYPE_ID = " + Id + ""; drdShowRecord = dmlService.J_ExecSqlReturnReader(strSQL); if (drdShowRecord == null) { return(false); } while (drdShowRecord.Read()) { lngSearchId = Id; txtEmailSubjectOnline.Text = drdShowRecord["EMAIL_SUBJECT_ONLINE"].ToString(); txtEmailSubjectOffline.Text = drdShowRecord["EMAIL_SUBJECT_OFFLINE"].ToString(); txtEmailSubjectItemDispatched.Text = drdShowRecord["EMAIL_SUBJECT_DESPATCH"].ToString(); txtOnlineMailBody.Text = drdShowRecord["EMAIL_BODY_ONLINE"].ToString(); txtOfflineMailBody.Text = drdShowRecord["EMAIL_BODY_OFFLINE"].ToString(); txtItemsDispatchedMailBody.Text = drdShowRecord["EMAIL_BODY_DESPATCH"].ToString(); txtFromEmail.Text = drdShowRecord["FROM_EMAIL"].ToString(); txtDisplayName.Text = drdShowRecord["DISPLAY_NAME"].ToString(); txtBCCEmail.Text = drdShowRecord["EMAIL_BCC"].ToString(); // if (Convert.ToInt32(drdShowRecord["INACTIVE_FLAG"].ToString()) == 1) { chkInactive.Checked = true; } else { chkInactive.Checked = false; } // drdShowRecord.Close(); drdShowRecord.Dispose(); txtEmailSubjectOnline.Select(); return(true); } drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(J_Msg.RecNotExist); lngSearchId = 0; if (strCheckFields == "") { strSQL = strQuery + "order by " + strOrderBy; } else { strSQL = strQuery + strCheckFields + "order by " + strOrderBy; } if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid return(false); } catch (Exception err_handler) { drdShowRecord.Close(); drdShowRecord.Dispose(); cmnService.J_UserMessage(err_handler.Message); return(false); } }