private void FrmClient_Load(object sender, EventArgs e)
{
cs.FrmStyle(this);
db.TxtAutoFill(TxtName, "MAS_CLIENT", "CLIENT_NAME");
TxtCode.Text = db.GetNewID("Mas_CLIENT", "CLIENT_Code").ToString();
DataSet ds = db.GetTableData("Select state_code,state_name||'('||state_code||')' state_name, action_type from mas_gst_state");
CmbState.DataSource = ds.Tables[0];
CmbState.DisplayMember = "state_name";
CmbState.ValueMember = "state_code";
if (LblPK.Text.Trim().Length > 0)
{
ds = db.GetTableData("select * from mas_CLIENT where CLIENT_Code=" + LblPK.Text);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
TxtCode.Text = dr["CLIENT_Code"].ToString();
TxtName.Text = dr["CLIENT_Name"].ToString();
TxtComm.Text = dr["CLIENT_Commission"].ToString();
if (dr["active_flag"].ToString() == "Y")
{
ChkActive.Checked = true;
}
else
{
ChkActive.Checked = false;
}
DataSet ds1 = db.GetTableData("Select * from mas_gst_state where state_code=" + dr["state_code"].ToString());
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
CmbState.Text = dr1["State_name"].ToString() + "(" + dr1["State_Code"].ToString() + ")";
}
TxtGSTNo.Text = dr["Gst_No"].ToString();
TxtPANNo.Text = dr["PAN_No"].ToString();
TxtRemarks.Text = dr["Remarks"].ToString();
}
}
}
}
private void FrmSubscription_Load(object sender, EventArgs e)
{
cs.FrmStyle(this);
DataSet ds = db.GetTableData("select sub_type_id, sub_type_name || '(' || sub_type_id || ')' sub_type_name, Action_type from mas_sub_type order by sub_type_name");
CmbSubType.DataSource = ds.Tables[0];
CmbSubType.ValueMember = "sub_type_id";
CmbSubType.DisplayMember = "sub_type_name";
ds = db.GetTableData("select state_id, state_name || '(' || state_id || ')' State_Name, Action_type from mas_state order by state_name");
CmbState.DataSource = ds.Tables[0];
CmbState.ValueMember = "State_ID";
CmbState.DisplayMember = "State_Name";
ds = db.GetTableData("select region_id, region_name || '('||region_id||')' region_name, action_type from mas_region order by region_name");
CmbRegion.DataSource = ds.Tables[0];
CmbRegion.DisplayMember = "Region_name";
CmbRegion.ValueMember = "Region_id";
ds = db.GetTableData("Select executive_id, executive_name || '('||executive_id||')' executive_name, action_type from mas_executive order by executive_name");
CmbExecutive.DataSource = ds.Tables[0];
CmbExecutive.DisplayMember = "executive_name";
CmbExecutive.ValueMember = "executive_id";
ds = db.GetTableData("select Sponsor_id, Sponsor_name || ',' || sponsor_address ||'(' || sponsor_id || ')' sponsor_name, action_type from mas_sponsor order by sponsor_name");
CmbSponsor.DataSource = ds.Tables[0];
CmbSponsor.DisplayMember = "sponsor_name";
CmbSponsor.ValueMember = "sponsor_id";
TxtVNo.Text = vouchernumber();
db.TxtAutoFill(TxtCity, "mas_subscriptions", "city_name");
db.TxtAutoFill(TxtPIN, "mas_subscriptions", "PIN_CODE");
db.TxtAutoFill(TxtOldVNo, "mas_sub_pay_details", "voucher_no");
if (LblPK.Text.Length > 0)
{
ds = db.GetTableData("select * from mas_sub_issues where pay_id=" + LblPK.Text.Trim() + " and invoice_code is not null");
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("Invoice already generated for this subscriptions", "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ds = db.GetTableData("select * from vew_mas_subscriptions ms where sub_id=" + LblPK.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
LblPK.Text = dr["sub_id"].ToString();
DataSet ds1 = db.GetTableData("select * from mas_state where state_id=" + dr["state_id"].ToString());
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
CmbState.Text = dr1["State_Name"].ToString() + "(" + dr1["State_ID"].ToString() + ")";
}
ds1 = db.GetTableData("select * from mas_district where district_id=" + dr["District_ID"].ToString());
foreach (DataRow dr2 in ds1.Tables[0].Rows)
{
CmbDistrict.Text = dr2["District_Name"].ToString() + "(" + dr2["District_ID"].ToString() + ")";
}
ds1 = db.GetTableData("select * from MAS_SUB_TYPE where sub_type_id=" + dr["sub_type"].ToString());
foreach (DataRow dr3 in ds1.Tables[0].Rows)
{
CmbSubType.Text = dr3["sub_type_name"].ToString() + "(" + dr3["sub_type_id"].ToString() + ")";
}
ds1 = db.GetTableData("select * from mas_region where region_id=" + dr["Region_ID"].ToString());
foreach (DataRow dr4 in ds1.Tables[0].Rows)
{
CmbRegion.Text = dr4["region_name"].ToString() + "(" + dr4["Region_ID"].ToString() + ")";
}
ds1 = db.GetTableData("Select * from mas_executive where executive_id=" + dr["executive_id"].ToString());
foreach (DataRow dr5 in ds1.Tables[0].Rows)
{
CmbExecutive.Text = dr5["executive_name"].ToString() + "(" + dr5["executive_id"].ToString() + ")";
}
DtpMnthFrm.Value = Convert.ToDateTime(dr["Period_frm"].ToString());
DtpMnthTo.Value = Convert.ToDateTime(dr["Period_to"].ToString());
TxtAdd.Text = dr["Address"].ToString();
TxtCity.Text = dr["City_Name"].ToString();
TxtEMail.Text = dr["Email_ID"].ToString();
TxtName.Text = dr["sub_name"].ToString();
TxtPhone.Text = dr["Contact_no"].ToString();
TxtPIN.Text = dr["PIN_Code"].ToString();
TxtRemarks.Text = dr["Remarks"].ToString();
TxtVNo.Text = dr["Voucher_No"].ToString();
TxtOldVNo.Text = dr["prev_voucher_no"].ToString();
CmbSponsor.Text = dr["sponsor_name"].ToString() + "," + dr["sponsor_address"].ToString() + "(" + dr["sponsor_id"].ToString() + ")";
ds1 = db.GetTableData("select * from mas_sub_issues where sub_id=" + dr["sub_id"].ToString());
if (ds1.Tables[0].Rows.Count > 0)
{
DtpMnthFrm.Enabled = false;
}
else
{
DtpMnthFrm.Enabled = true;
}
}
}
}
}