private void FillVoucherType()
{
try
{
objNarrMastermodel = new NarrationMasterModel()
{
Ind = 22,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
// YrCD = GlobalSession.YrCD,
//VchType = Convert.ToInt32(Session["VchType"]),
};
string uri = string.Format("NarrationMaster/FillVoucher");
DataTable WarehouseVoucherlist = CommonCls.ApiPostDataTable(uri, objNarrMastermodel);
if (WarehouseVoucherlist.Rows.Count > 0)
{
ddlFillVoucher.DataSource = WarehouseVoucherlist;
ddlFillVoucher.DataTextField = "DocTypeDesc";
ddlFillVoucher.DataValueField = "DocTypeID";
ddlFillVoucher.DataBind();
ddlFillVoucher.Items.Insert(0, new ListItem("-- Select --", "0"));
}
}
catch (Exception ex)
{
// ShowMessage(ex.Message, false);
}
}
public DataTable SaveProcess(NarrationMasterModel ObjNrrationMastModel)
{
objNarrMasterDA = new NarrationMasterDataAccess();
DataTable SaveList = objNarrMasterDA.SaveNarration(ObjNrrationMastModel);
return(SaveList);
}
public DataTable FillVoucher(NarrationMasterModel ObjNrrationMastModel)
{
objNarrMasterDA = new NarrationMasterDataAccess();
DataTable fillVoucherType = objNarrMasterDA.LoadVoucherType(ObjNrrationMastModel);
return(fillVoucherType);
}
public DataTable FillGrid(NarrationMasterModel ObjNrrationMastModel)
{
objNarrMasterDA = new NarrationMasterDataAccess();
DataTable fillGrid = objNarrMasterDA.FillGridView(ObjNrrationMastModel);
return(fillGrid);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = lblMsg.CssClass = "";
if (!CommonCls.CheckGUIDIsValid())
{
return;
}
if (ddlFillVoucher.SelectedValue == "0")
{
ddlFillVoucher.Focus();
ShowMessage("Select Voucher Type..!", false);
return;
}
if (string.IsNullOrEmpty(txtSnarration.Text.Trim()))
{
txtSnarration.Focus();
ShowMessage("Enter Narration..!", false);
return;
}
objNarrMastermodel = new NarrationMasterModel()
{
Ind = 2,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
User = GlobalSession.UserID,
IP = GlobalSession.IP,
};
objNarrMastermodel.DocTypeID = Convert.ToInt32(ddlFillVoucher.SelectedItem.Value);
objNarrMastermodel.NarrDesc = txtSnarration.Text;
string uri = string.Format("NarrationMaster/SaveProcess");
DataTable WarehouSaveProcess = CommonCls.ApiPostDataTable(uri, objNarrMastermodel);
if (WarehouSaveProcess.Rows.Count > 0)
{
ShowMessage("Data Is SucessFully Saved..!", true);
}
else
{
ShowMessage("Data Is Not Saved SucessFully..!", false);
}
FillGrid();
clear();
}
catch (Exception ex)
{
// ShowMessage(ex.Message, false);
}
}
internal DataTable SaveNarration(NarrationMasterModel ObjNrrationMastModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPNarration";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjNrrationMastModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjNrrationMastModel.OrgID);
// ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjNrrationMastModel.BrID);
// ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjNrrationMastModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjNrrationMastModel.DocTypeID);
ClsCon.cmd.Parameters.AddWithValue("@NarrDesc", ObjNrrationMastModel.NarrDesc);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjNrrationMastModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjNrrationMastModel.User);
// ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjWarehouseModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSaveNarration = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSaveNarration);
dtSaveNarration.TableName = "success";
}
catch (Exception)
{
dtSaveNarration = new DataTable();
dtSaveNarration.TableName = "error";
return(dtSaveNarration);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSaveNarration);
}
private void FillGrid()
{
objNarrMastermodel = new NarrationMasterModel()
{
Ind = 1,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
DocTypeID = Convert.ToInt32(ddlFillVoucher.SelectedValue),
};
string uri = string.Format("NarrationMaster/FillGrid");
DataTable WarehouseFillGridlist = CommonCls.ApiPostDataTable(uri, objNarrMastermodel);
if (WarehouseFillGridlist.Rows.Count > 0)
{
grdNarration.DataSource = WarehouseFillGridlist;
grdNarration.DataBind();
}
}
internal DataTable LoadVoucherType(NarrationMasterModel ObjNrrationMastModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjNrrationMastModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjNrrationMastModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjNrrationMastModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjNrrationMastModel.YrCD);
// ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjWarehouseModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtNarrationVoucherType = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtNarrationVoucherType);
dtNarrationVoucherType.TableName = "success";
}
catch (Exception)
{
dtNarrationVoucherType = new DataTable();
dtNarrationVoucherType.TableName = "error";
return(dtNarrationVoucherType);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtNarrationVoucherType);
}
