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