private void BindApplyType()
{
var dataSource = EnumAttribute.GetDict <ApplyInvoiceType>();
DdlType.DataSource = dataSource;
DdlType.DataBind();
DdlType.SelectedValue = string.Format("{0}", (int)ApplyInvoiceType.All);
}
public void Clear()
{
TxtDiffAmt.Text = "";
TxtActualAmt.Text = "";
TxtContraAmt.Text = "";
ddlBankName.SelectedValue = "0";
DdlType.SelectedValue = "0";
DdlType.Focus();
}
private void FillFormEdit(Business.ClauseRecord objClause)
{
LblClauseIdVal.Text = objClause.ClauseId.ToString();
TxtName.Text = objClause.ClauseName;
TxtClauseNum.Text = objClause.ClauseNumber;
if (objClause.ClauseType.Equals("Subclause"))
{
ToggleSpecial(false);
LblOwnerVal.Text = objCommon.GetEmpname(objClause.ParentOwner.ToString());
trClausename.Visible = true;
trparentno.Visible = true;
DivClauseNameView.Visible = true;
LblClauseNameVal.Text = objClause.ParentClause;
DivClauseNumView.Visible = true;
LblParentnoVal.Text = objClause.ParentClauseNum;
SpanClauseName.Visible = false;
LblTypeVal.Text = objClause.ParentContractName;
ViewState["parentcontractid"] = objClause.ParentContract;
ViewState["parentownerid"] = objClause.ParentOwner;
ViewState["parentclauseid"] = objClause.ParentId;
}
else
{
ToggleSpecial(true);
TxtOwneradmin.Text = objClause.OwnerName;
trClausename.Visible = false;
trparentno.Visible = false;
}
int count = DdlType.Items.Count;
if (count == 0)
{
DdlType.DataSourceID = "SDSContract";
DdlType.DataTextField = "CONTRACT_NAME";
DdlType.DataValueField = "CONTRACT_ID";
DdlType.DataBind();
}
if (!string.IsNullOrEmpty(objClause.ContractId.ToString()))
{
if (DdlType.Items.FindByValue(objClause.ContractId.ToString()) != null)
{
DdlType.ClearSelection();
DdlType.Items.FindByValue(objClause.ContractId.ToString()).Selected = true;
}
else
{
DdlType.SelectedIndex = 0;
}
}
DivEdit.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Uname"] != null)
{
Master.Li.Visible = false;
Master.Lo.Visible = true;
if (Session["UType"].ToString() == "Administrator")
{
Master.Aut.Visible = true;
}
else
{
Response.Redirect("~/NotAut.aspx");
}
}
else
{
Response.Redirect("~/Master.aspx");
}
if (!IsPostBack)
{
string str = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(str))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from tbluser";
cmd.Connection = con;
con.Open();
DdlUser.DataSource = cmd.ExecuteReader();
DdlUser.DataTextField = "UName";
//DdlUser.DataValueField = "UName";
DdlUser.DataBind();
con.Close();
DdlUser.Items.Insert(0, "Select One");
DdlUser.SelectedIndex = 0;
cmd.CommandText = "select * from tblUType";
cmd.Connection = con;
con.Open();
DdlType.DataSource = cmd.ExecuteReader();
DdlType.DataTextField = "UType";
DdlType.DataValueField = "UTypeId";
DdlType.DataBind();
con.Close();
DdlType.Items.Insert(0, "Select One");
DdlType.SelectedIndex = 0;
}
DdlType.Enabled = false;
BtnSave.Enabled = false;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (TxtDiffAmt.Text != "0")
{
string ET = "";
string setno = BD.GetSetNo(Session["EntryDate"].ToString(), "InOutSetno", Session["BRCD"].ToString()); //OWGCL.GetNewSetNo(BRCD);
int ScrollNo, RC;
string GLCODE = BD.GetAccTypeGL(ddlBankName.SelectedValue, Session["BRCD"].ToString());
string[] GLC = GLCODE.Split('_');
ScrollNo = 1;
ET = rdbCredit.Checked == true ? "C" : "D";
if (rdbCredit.Checked == true && DdlType.SelectedValue == "1")
{
RC = OWGCL.InsertNewSetNo(GLC[1].ToString(), Session["EntryDate"].ToString(), Session["BRCD"].ToString(), ddlBankName.SelectedValue, "0", "0", "", "Inward Clearing", ddlBankName.SelectedValue, "0", "0", "01/01/1900", "0", TxtContraAmt.Text, Session["MID"].ToString(), "", Convert.ToInt32(setno), ScrollNo, Convert.ToInt32(ddlBankName.SelectedValue), "C", "1001", Dll_Session.SelectedValue);
if (RC > 0)
{
lblMessage.Text = "Record Added sucessfully with Recipt No " + setno;
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Zoneposting_Add _" + setno + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Getamount("IN");
GetDiffrence("IN");
ModalPopup.Show(this.Page);
Clear();
}
}
else if (rdbDebit.Checked == true && DdlType.SelectedValue == "2")
{
RC = OWGCLG.InsertNewSetNo(GLC[1].ToString(), Session["EntryDate"].ToString(), Session["BRCD"].ToString(), ddlBankName.SelectedValue, "0", "0", "", "Outward Clearing", ddlBankName.SelectedValue, "0", "0", "01/01/1900", "0", TxtContraAmt.Text, Session["MID"].ToString(), "", Convert.ToInt32(setno), ScrollNo, ddlBankName.SelectedValue, "D", "O", "1001", Dll_Session.SelectedValue);
if (RC > 0)
{
lblMessage.Text = "Record Added sucessfully with Recipt No " + setno;
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Zoneposting_Add _" + setno + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Getamount("OUT");
GetDiffrence("OUT");
ModalPopup.Show(this.Page);
Clear();
}
}
else if (rdbCredit.Checked == true && DdlType.SelectedValue == "4")
{
RC = OWGCLG.InsertNewSetNoReturn(GLC[1].ToString(), Session["EntryDate"].ToString(), Session["BRCD"].ToString(), ddlBankName.SelectedValue, "0", "0", "", "OW Clg Return", ddlBankName.SelectedValue, "0", "0", "01/01/1900", "0", TxtContraAmt.Text, Session["MID"].ToString(), "", Convert.ToInt32(setno), ScrollNo, ddlBankName.SelectedValue, "C", "O", "1001", Dll_Session.SelectedValue);
if (RC > 0)
{
lblMessage.Text = "Record Added sucessfully with Recipt No " + setno;
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Zoneposting_Add _" + setno + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Getamount("OWRT");
GetDiffrence("OWRT");
ModalPopup.Show(this.Page);
Clear();
}
}
else if (rdbDebit.Checked == true && DdlType.SelectedValue == "3")
{
RC = OWGCLG.InsertNewSetNoReturn(GLC[1].ToString(), Session["EntryDate"].ToString(), Session["BRCD"].ToString(), ddlBankName.SelectedValue, "0", "0", "", "IW Clg Return", ddlBankName.SelectedValue, "0", "0", "01/01/1900", "0", TxtContraAmt.Text, Session["MID"].ToString(), "", Convert.ToInt32(setno), ScrollNo, ddlBankName.SelectedValue, "D", "I", "1001", Dll_Session.SelectedValue);
if (RC > 0)
{
lblMessage.Text = "Record Added sucessfully with Recipt No " + setno;
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Zoneposting_Add _" + setno + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Getamount("IWRT");
GetDiffrence("IWRT");
ModalPopup.Show(this.Page);
Clear();
}
}
}
else
{
WebMsgBox.Show("Voucher Already Posted .....!", this.Page);
Clear();
DdlType.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
