public static string GetNewVoucherNo(string sTableName, string sColumn, int NoOfChar, string dealerCode)
{
//#GET MAX ID FROM TABLE
string sQuery = "SELECT MAX(" + sColumn + ") MAXID FROM " + sTableName + " where CompCode = '" + dealerCode + "'";
SqlDataReader drItemVal = SqlHelper.ExecuteReader(General.GetFAMConString(), CommandType.Text, sQuery);
//SqlDataReader drItemVal = null;
string sNewVersion = "0";
int iNewVersion;
string date = DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("yyyy-MM-dd");
string subDate = date.Substring(2);
try
{
if (drItemVal.HasRows)
{
drItemVal.Read();
sNewVersion = sysfun.GetNullString(drItemVal["MAXID"]);
drItemVal.Close();
if (sNewVersion == "")
{
sNewVersion = "0";
iNewVersion = Convert.ToInt32(sNewVersion) + 1;
sNewVersion = Convert.ToString(iNewVersion).PadLeft(NoOfChar, '0');
}
else
{
string sub = sNewVersion.Substring(12);
iNewVersion = Convert.ToInt32(sub) + 1;
sNewVersion = Convert.ToString(iNewVersion).PadLeft(NoOfChar, '0');
}
return("JV-" + subDate + "-" + sNewVersion);
}
else
{
iNewVersion = 0;
sNewVersion = Convert.ToString(iNewVersion).PadLeft(NoOfChar, '0');
return("JV-" + subDate + "-" + sNewVersion);
}
}
catch (Exception ex)
{
//ShowError();
drItemVal.Close();
}
return(sNewVersion);
}
private void LoadData()
{
string ccode = ddlCustomer.SelectedValue;
ddlAcctof.SelectedIndex = ddlCustomer.SelectedIndex;
//txtCustomerName.Text = sysFuns.GetCustomerName(ccode, Session["DealerCode"].ToString());
ddlAcctof.Enabled = true;
txtRegDate.Enabled = true;
txtRegNo.Enabled = true;
ddlVersion.Enabled = true;
txtEngineNo.Enabled = true;
ddlProduct.Enabled = true;
txtChassisNo.Enabled = true;
ddlColor.Enabled = true;
txtInvDate.Enabled = true;
ddlInsCo.Enabled = true;
txtWBNo.Enabled = true;
txtPolicyNo.Enabled = true;
ddlBrand.Enabled = true;
btnDeleteInv.Enabled = true;
btnSaveInv.Enabled = true;
txtInvoiceNo.Enabled = true;
txtDeliveryDate.Enabled = true;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.VarChar, 5),
new SqlParameter("@CusCode", SqlDbType.VarChar, 50)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFun.GetNullString(ccode);
gvCustVeh.DataSource = sysFuns.FillDataSetOrEmptyRow("sp_2W_Service_CusVeh_Select", param);
gvCustVeh.DataBind();
gvCustVeh.Enabled = true;
}