protected void BtncallUpd_Click(object sender, EventArgs e)
{
try
{
if (BtncallUpd.Text == "UPDATE")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
}
else
{
OP_STOCK_BALLogicLayer insert = new OP_STOCK_BALLogicLayer();
insert.COMP_CODE = Session["COMP_CODE"].ToString();
insert.BRANCH_CODE = Session["BRANCH_CODE"].ToString();
// insert.TRAN_DATE = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //HfTransDate.Value.Trim();
// insert.TRAN_NO = HfTransNo.Value.Trim();
insert.YRDT1 = Convert.ToDateTime(Session["FIN_YEAR"]).ToString("yyyy-MM-dd");
insert.TRNDT = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");//TxtTranDate.Text.Trim();
insert.SRNO = HfSrNo.Value.Trim();
insert.SCODE = HfDetailSCode.Value.Trim().ToUpper();
if (TxtQuantity.Text == string.Empty)
{
insert.QTY = "0";
}
else
{
insert.QTY = TxtQuantity.Text.Trim();
}
if (TxtRate.Text == string.Empty)
{
insert.RATE = "0";
}
else
{
insert.RATE = TxtRate.Text.Trim();
}
if (TxtAmount.Text == string.Empty)
{
insert.AMT = "0";
}
else
{
insert.AMT = TxtAmount.Text.Trim();
}
insert.REMARK = "";
insert.INS_USERID = Session["USERNAME"].ToString();
insert.INS_TERMINAL = Session["PC"].ToString();
insert.INS_DATE = "";
insert.UPD_USERID = Session["USERNAME"].ToString();
insert.UPD_TERMINAL = Session["PC"].ToString();
insert.UPD_DATE = "";
if (BtncallUpd.Text.Trim().ToUpper() == "SAVE")
{
string str = OP_STOCK_BALLogicLayer.InsertSTOCK_OP_BALDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "STOCK OPENING BALANCE DETAIL ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
}
catch (Exception)
{
throw;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
#region INSERT OPENING STOCK MASTER
OP_STOCK_BALLogicLayer insert = new OP_STOCK_BALLogicLayer();
insert.COMP_CODE = HfCompCode.Value.Trim();
insert.BRANCH_CODE = HfBranchCode.Value.Trim();
insert.TRAN_DATE = Convert.ToDateTime(HfTransDate.Value.Trim().ToString()).ToString("MM-dd-yyyy"); //HfTransDate.Value.Trim();
insert.TRAN_NO = HfTransNo.Value.Trim();
insert.YRDT1 = Convert.ToDateTime(HfYearDate1.Value.Trim()).ToString("yyyy-MM-dd");
insert.TRNDT = Convert.ToDateTime(TxtTranDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");//TxtTranDate.Text.Trim();
insert.SRNO = HfSrNo.Value.Trim();
insert.SCODE = HfDetailSCode.Value.Trim().ToUpper();
if (TxtQuantity.Text == string.Empty)
{
insert.QTY = "0";
}
else
{
insert.QTY = TxtQuantity.Text.Trim();
}
if (TxtRate.Text == string.Empty)
{
insert.RATE = "0";
}
else
{
insert.RATE = TxtRate.Text.Trim();
}
if (TxtAmount.Text == string.Empty)
{
insert.AMT = "0";
}
else
{
insert.AMT = TxtAmount.Text.Trim();
}
insert.REMARK = "";
insert.INS_USERID = Session["USERNAME"].ToString();
insert.INS_TERMINAL = Session["PC"].ToString();
insert.INS_DATE = "";
insert.UPD_USERID = Session["USERNAME"].ToString();
insert.UPD_TERMINAL = Session["PC"].ToString();
insert.UPD_DATE = "";
#endregion
if (btnSave.Text.Trim().ToUpper() == "SAVE")
{
string str = OP_STOCK_BALLogicLayer.InsertSTOCK_OP_BALDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "STOCK OPENING BALANCE DETAIL ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
else
{
string str = OP_STOCK_BALLogicLayer.UpdateBRAND_COMPLAIN_MASDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "STOCK OPENING BALANCE DETAIL UPDATE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "STOCK OPENING BALANCE MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : STOCK OPENING BALANCE DETAIL NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
catch (Exception)
{
throw;
}
}
