private void TxtBarCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TxtItemName.Focus();
}
}
protected void TxtItemGroupName_TextChanged(object sender, EventArgs e)
{
try
{
Session["itrmgroupid"] = HifItemGroup.Value;
TxtItemName.Focus();
}
catch (Exception ex)
{
}
}
private void Item_Load(object sender, EventArgs e)
{
LblHeaderText.BackColor = Color.FromName(CmC.LblBackColor);
LblHeaderText.Font = new Font(CmC.LblFontStyle, CmC.LblFontSize); //, 17pt, style=Bold
LblHeaderText.Font = new Font(LblHeaderText.Font, FontStyle.Bold);
LblHeaderText.ForeColor = Color.FromName(CmC.LblFontColor);
TxtItemName.Focus();
DataGridItemMaster.AutoGenerateColumns = false;
this.AcceptButton = BtnInsertUpdate;
GetItemMasterList(0, "");
}
private void TxtItemName_TextChanged(object sender, EventArgs e)
{
char[] c = TxtItemName.Text.ToCharArray();
int j;
for (j = 0; j < TxtItemName.Text.Length; j++)
{
if (j == 0)
{
c[j] = c[j].ToString().ToUpper()[0];
}
else
{
c[j] = c[j].ToString().ToLower()[0];
}
}
TxtItemName.Text = new string(c);
TxtItemName.Select(TxtItemName.Text.Length, 1);
}
private void BtnInsertUpdate_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(TxtItemName.Text.ToString()))
{
messageShow.singlemsgtext("Item name should not be empty");
TxtItemName.Focus();
return;
}
var item_master = new ItemMaster
{
ItemCode = ItemCode,
ItemName = TxtItemName.Text.ToString(),
OperationType = BtnInsertUpdate.Text.ToString() == "Save" ? 1 : 2
};
int id = _instanceRepository.InsertUpdateDeleteItemMaster(item_master);
if (id >= 1)
{
messageShow.singlemsgtext(item_master.OperationType == 1 ? "New Item added successfully" : "Item updated successfully");
item_master.ItemName = "";
ResetControlles();
}
else if (id == -1)
{
messageShow.singlemsgtext("The item name already exists, please try another name!");
}
else
{
messageShow.singlemsgtext("Error in item insert/update");
}
}
catch (Exception _exception)
{
CmC.InsertException(_exception);
messageShow.singlemsgtext(CmC.ExceptionErrorMessage);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
try
{
ds = cn.RunSql("sp_getsrno '1','0','" + Request.Cookies["CompID"].Value + "','" + Request.Cookies["BranchID"].Value + "','" + Request.Cookies["AccYear"].Value + "'", "select");
TxtSRNo.Text = ds.Tables[0].Rows[0]["srno"] != DBNull.Value ? ds.Tables[0].Rows[0]["srno"].ToString() : "";
ds = cn.RunSql("sp_getaddlesspurchase '2'", "select");
GvAddLess.DataSource = ds;
GvAddLess.DataBind();
ds = cn.RunSql("sp_Searchaccount 'Purchase','" + Request.Cookies["CompID"].Value + "'", "Sales");
DDLSalesAccount.DataSource = ds;
DDLSalesAccount.DataBind();
if (Request.QueryString["id"] != null)
{
ds = cn.RunSql("sp_listPurchase '" + Request.QueryString["id"] + "','" + Request.Cookies["CompID"].Value + "','" + Request.Cookies["BranchID"].Value + "','" + Request.Cookies["AccYear"].Value + "'", "select");
TxtSRNo.Text = ds.Tables[0].Rows[0]["nSrNo"] != DBNull.Value ? ds.Tables[0].Rows[0]["nSrNo"].ToString() : "";
TxtDate.Text = ds.Tables[0].Rows[0]["dDate"] != DBNull.Value ? ds.Tables[0].Rows[0]["dDate"].ToString() : "";
DDLSalesAccount.SelectedValue = ds.Tables[0].Rows[0]["cSalesAcc"] != DBNull.Value ? ds.Tables[0].Rows[0]["cSalesAcc"].ToString() : "";
LblGrossRs.Text = ds.Tables[0].Rows[0]["nGrossRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nGrossRs"].ToString() : "";
TxtVatPer.Text = ds.Tables[0].Rows[0]["nVatPer"] != DBNull.Value ? ds.Tables[0].Rows[0]["nVatPer"].ToString() : "";
TxtVatRs.Text = ds.Tables[0].Rows[0]["nCGSTRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nCGSTRs"].ToString() : "";
TxtExtraPer.Text = ds.Tables[0].Rows[0]["nExtraPer"] != DBNull.Value ? ds.Tables[0].Rows[0]["nExtraPer"].ToString() : "";
TxtExtraRs.Text = ds.Tables[0].Rows[0]["nSGSTRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nSGSTRs"].ToString() : "";
TxtIGST.Text = ds.Tables[0].Rows[0]["nIGSTRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nIGSTRs"].ToString() : "";
TxtDisPer.Text = ds.Tables[0].Rows[0]["nDiscPer"] != DBNull.Value ? ds.Tables[0].Rows[0]["nDiscPer"].ToString() : "";
TxtDisRs.Text = ds.Tables[0].Rows[0]["nDiscRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nDiscRs"].ToString() : "";
LblNetRs.Text = ds.Tables[0].Rows[0]["nNetRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nNetRs"].ToString() : "";
LblAmt.Text = ds.Tables[0].Rows[0]["nAmt"] != DBNull.Value ? ds.Tables[0].Rows[0]["nAmt"].ToString() : "";
HifCustomer.Value = ds.Tables[0].Rows[0]["ccustomer"] != DBNull.Value ? ds.Tables[0].Rows[0]["ccustomer"].ToString() : "";
TxtCustomer.Text = ds.Tables[0].Rows[0]["cName"] != DBNull.Value ? ds.Tables[0].Rows[0]["cName"].ToString() : "";
LblTotalQty.Text = ds.Tables[2].Rows[0]["TotalQty"] != DBNull.Value ? ds.Tables[2].Rows[0]["TotalQty"].ToString() : "";
TxtTransporterID.Text = ds.Tables[0].Rows[0]["cTransporterID"] != DBNull.Value ? ds.Tables[0].Rows[0]["cTransporterID"].ToString() : "";
TxtTransporterName.Text = ds.Tables[0].Rows[0]["cTransporterName"] != DBNull.Value ? ds.Tables[0].Rows[0]["cTransporterName"].ToString() : "";
TxtVehicleNo.Text = ds.Tables[0].Rows[0]["cVehicleNo"] != DBNull.Value ? ds.Tables[0].Rows[0]["cVehicleNo"].ToString() : "";
DDLCashCredit.SelectedValue = ds.Tables[0].Rows[0]["nCashCredit"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["nCashCredit"]) == true ? "1" : "0" : "0";
LblRoundOff.Text = ds.Tables[0].Rows[0]["nRoundOff"] != DBNull.Value ? ds.Tables[0].Rows[0]["nRoundOff"].ToString() : "";
if (LblAmt.Text == "")
{
LblAmt.Text = ds.Tables[0].Rows[0]["nGrossRs"] != DBNull.Value ? ds.Tables[0].Rows[0]["nGrossRs"].ToString() : "";
}
GVItem.DataSource = ds.Tables[1];
GVItem.DataBind();
GvAddLess.DataSource = ds.Tables[4];
GvAddLess.DataBind();
if (Request.QueryString["cid"] != null)
{
ds = cn.RunSql("sp_listPurchase '" + Request.QueryString["id"] + "','" + Request.Cookies["CompID"].Value + "','" + Request.Cookies["BranchID"].Value + "','" + Request.Cookies["AccYear"].Value + "','" + Request.QueryString["cid"] + "'", "select");
TxtItemGroupName.Text = ds.Tables[3].Rows[0]["cItemGroupName"] != DBNull.Value ? ds.Tables[3].Rows[0]["cItemGroupName"].ToString() : "";
TxtItemName.Text = ds.Tables[3].Rows[0]["cItem"] != DBNull.Value ? ds.Tables[3].Rows[0]["cItem"].ToString() : "";
HifItemGroup.Value = ds.Tables[3].Rows[0]["itemgrpid"] != DBNull.Value ? ds.Tables[3].Rows[0]["itemgrpid"].ToString() : "";
HifItem.Value = ds.Tables[3].Rows[0]["itemid"] != DBNull.Value ? ds.Tables[3].Rows[0]["itemid"].ToString() : "";
TxtDescription.Text = ds.Tables[3].Rows[0]["cDescription"] != DBNull.Value ? ds.Tables[3].Rows[0]["cDescription"].ToString() : "";
TxtSize.Text = ds.Tables[3].Rows[0]["nSize"] != DBNull.Value ? ds.Tables[3].Rows[0]["nSize"].ToString() : "";
TxtMRP.Text = ds.Tables[3].Rows[0]["nSaleRate"] != DBNull.Value ? ds.Tables[3].Rows[0]["nSaleRate"].ToString() : "";
txtDiscPerChild.Text = ds.Tables[3].Rows[0]["nDisPer"] != DBNull.Value ? ds.Tables[3].Rows[0]["nDisPer"].ToString() : "";
TxtDisRsChild.Text = ds.Tables[3].Rows[0]["nDisRs"] != DBNull.Value ? ds.Tables[3].Rows[0]["nDisRs"].ToString() : "";
TxtQty.Text = ds.Tables[3].Rows[0]["nqty"] != DBNull.Value ? ds.Tables[3].Rows[0]["nqty"].ToString() : "";
TxtPurchaseRate.Text = ds.Tables[3].Rows[0]["nPurchaseRate"] != DBNull.Value ? ds.Tables[3].Rows[0]["nPurchaseRate"].ToString() : "";
LblTotal.Text = ds.Tables[3].Rows[0]["nTotal"] != DBNull.Value ? ds.Tables[3].Rows[0]["nTotal"].ToString() : "";
}
if (Request.QueryString["D"] != null)
{
ddldelete.Visible = true;
btnsave.Text = "Delete";
}
TxtItemName.Focus();
}
}
catch (Exception ex)
{
}
}
}
private void TxtItemName_LayoutUpdated(object sender, EventArgs e)
{
TxtItemName.Focus();
}
private void WdwItemDetail_Loaded(object sender, RoutedEventArgs e)
{
TxtItemName.Focus();
}
public ItemEntry()
{
ItemEntryViewModel.Errors = 0;
InitializeComponent();
TxtItemName.Focus();
}
private void BtnAddNew_Click(object sender, RoutedEventArgs e)
{
TxtItemName.Focus();
//TxtPurchasePrice.Text = "";
TxtSellPrice.Text = "";
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
TxtItemName.Focus();
}
public RoomResourceEntry()
{
RoomResourceEntryViewModel.Errors = 0;
InitializeComponent();
TxtItemName.Focus();
}
private void WdwMessage_Loaded(object sender, RoutedEventArgs e)
{
TxtItemName.Focus();
}
public MessageEntry()
{
MessageViewModel.Errors = 0;
InitializeComponent();
TxtItemName.Focus();
}
