public Pos_TransactionType GetPos_TransactionTypeFromReader(IDataReader reader) { try { Pos_TransactionType pos_TransactionType = new Pos_TransactionType ( (int)reader["Pos_TransactionTypeID"], reader["TransactionTypeName"].ToString(), reader["CentralStockFormula"].ToString(), reader["ShowRoomFormula"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString() ); try { pos_TransactionType.ExtraField4 = reader["ExtraField4"].ToString(); pos_TransactionType.ExtraField5 = reader["ExtraField5"].ToString(); pos_TransactionType.ExtraField6 = reader["ExtraField6"].ToString(); pos_TransactionType.Sorting = int.Parse(pos_TransactionType.ExtraField5); } catch (Exception ex) { pos_TransactionType.ExtraField4 = ""; pos_TransactionType.ExtraField5 = ""; pos_TransactionType.ExtraField6 = ""; } return(pos_TransactionType); } catch (Exception ex) { return(null); } }
public static Pos_TransactionType GetPos_TransactionTypeByID(int id) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); pos_TransactionType = sqlPos_TransactionTypeProvider.GetPos_TransactionTypeByID(id); return pos_TransactionType; }
public static Pos_TransactionType GetPos_TransactionTypeByID(int id) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); pos_TransactionType = sqlPos_TransactionTypeProvider.GetPos_TransactionTypeByID(id); return(pos_TransactionType); }
private void showPos_TransactionTypeData() { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(Int32.Parse(Request.QueryString["pos_TransactionTypeID"])); txtTransactionTypeName.Text = pos_TransactionType.TransactionTypeName; txtCentralStockFormula.Text = pos_TransactionType.CentralStockFormula; txtShowRoomFormula.Text = pos_TransactionType.ShowRoomFormula; txtExtraField1.Text = pos_TransactionType.ExtraField1; txtExtraField2.Text = pos_TransactionType.ExtraField2; txtExtraField3.Text = pos_TransactionType.ExtraField3; }
protected void btnReceived_Click(object sender, EventArgs e) { int Pos_TransactionMasterID = int.Parse(Request.QueryString["Pos_TransactionMasterID"]); Pos_TransactionMaster pos_TransactionMaster = Pos_TransactionMasterManager.GetPos_TransactionMasterByID(Pos_TransactionMasterID); Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(pos_TransactionMaster.Pos_TransactionTypeID); string sql = "Declare @Count int; "; sql += "update Pos_TransactionMaster set ExtraField5='' where Pos_TransactionMasterID=" + Pos_TransactionMasterID + ";"; List <Pos_Product> items = new List <Pos_Product>(); items = Pos_ProductManager.GetAllPos_ProductsByTrasactionMasterID(Pos_TransactionMasterID); foreach (Pos_Product pos_Transaction in items) { if (pos_TransactionMaster.WorkSatationID == 1 && transactionType.CentralStockFormula != "0") { //For head office Central Stock sql += "Update Pos_Product set ExtraField1 =(cast(ExtraField1 as decimal(10,2)) + ((" + transactionType.CentralStockFormula + ")*" + pos_Transaction.ExtraField1 + ")) where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + ";"; } else if (pos_TransactionMaster.WorkSatationID != 1 && transactionType.ShowRoomFormula != "0") { sql += @" set @Count= ( select COUNT(*) from Pos_WorkStationStock where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID=" + pos_TransactionMaster.WorkSatationID + @" ) if @Count = 0 BEGIN INSERT INTO [Pos_WorkStationStock] ([WorkStationID] ,[ProductID] ,[Stock]) VALUES(" + pos_TransactionMaster.WorkSatationID + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + pos_Transaction.ExtraField1 + @"); END ELSE BEGIN Update Pos_WorkStationStock set Stock += ((+1)*" + pos_Transaction.ExtraField1 + @") where WorkStationID=" + pos_TransactionMaster.WorkSatationID + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; END; "; } CommonManager.SQLExec(sql); } Response.Redirect("TransactionPrint.aspx?Pos_TransactionMasterID=" + Pos_TransactionMasterID); }
private void showPos_TransactionTypeData() { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(Int32.Parse(Request.QueryString["pos_TransactionTypeID"])); txtTransactionTypeName.Text = pos_TransactionType.TransactionTypeName; txtCentralStockFormula.Text = pos_TransactionType.CentralStockFormula; txtShowRoomFormula.Text = pos_TransactionType.ShowRoomFormula; txtExtraField1.Text = pos_TransactionType.ExtraField1; txtExtraField2.Text = pos_TransactionType.ExtraField2; txtExtraField3.Text = pos_TransactionType.ExtraField3; }
protected void btnAdd_Click(object sender, EventArgs e) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType.TransactionTypeName = txtTransactionTypeName.Text; pos_TransactionType.CentralStockFormula = txtCentralStockFormula.Text; pos_TransactionType.ShowRoomFormula = txtShowRoomFormula.Text; pos_TransactionType.ExtraField1 = txtExtraField1.Text; pos_TransactionType.ExtraField2 = txtExtraField2.Text; pos_TransactionType.ExtraField3 = txtExtraField3.Text; int resutl = Pos_TransactionTypeManager.InsertPos_TransactionType(pos_TransactionType); Response.Redirect("AdminPos_TransactionTypeDisplay.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType.TransactionTypeName = txtTransactionTypeName.Text; pos_TransactionType.CentralStockFormula = txtCentralStockFormula.Text; pos_TransactionType.ShowRoomFormula = txtShowRoomFormula.Text; pos_TransactionType.ExtraField1 = txtExtraField1.Text; pos_TransactionType.ExtraField2 = txtExtraField2.Text; pos_TransactionType.ExtraField3 = txtExtraField3.Text; int resutl = Pos_TransactionTypeManager.InsertPos_TransactionType(pos_TransactionType); Response.Redirect("AdminPos_TransactionTypeDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(Int32.Parse(Request.QueryString["pos_TransactionTypeID"])); Pos_TransactionType tempPos_TransactionType = new Pos_TransactionType(); tempPos_TransactionType.Pos_TransactionTypeID = pos_TransactionType.Pos_TransactionTypeID; tempPos_TransactionType.TransactionTypeName = txtTransactionTypeName.Text; tempPos_TransactionType.CentralStockFormula = txtCentralStockFormula.Text; tempPos_TransactionType.ShowRoomFormula = txtShowRoomFormula.Text; tempPos_TransactionType.ExtraField1 = txtExtraField1.Text; tempPos_TransactionType.ExtraField2 = txtExtraField2.Text; tempPos_TransactionType.ExtraField3 = txtExtraField3.Text; bool result = Pos_TransactionTypeManager.UpdatePos_TransactionType(tempPos_TransactionType); Response.Redirect("AdminPos_TransactionTypeDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { Pos_TransactionType pos_TransactionType = new Pos_TransactionType(); pos_TransactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(Int32.Parse(Request.QueryString["pos_TransactionTypeID"])); Pos_TransactionType tempPos_TransactionType = new Pos_TransactionType(); tempPos_TransactionType.Pos_TransactionTypeID = pos_TransactionType.Pos_TransactionTypeID; tempPos_TransactionType.TransactionTypeName = txtTransactionTypeName.Text; tempPos_TransactionType.CentralStockFormula = txtCentralStockFormula.Text; tempPos_TransactionType.ShowRoomFormula = txtShowRoomFormula.Text; tempPos_TransactionType.ExtraField1 = txtExtraField1.Text; tempPos_TransactionType.ExtraField2 = txtExtraField2.Text; tempPos_TransactionType.ExtraField3 = txtExtraField3.Text; bool result = Pos_TransactionTypeManager.UpdatePos_TransactionType(tempPos_TransactionType); Response.Redirect("AdminPos_TransactionTypeDisplay.aspx"); }
public bool UpdatePos_TransactionType(Pos_TransactionType pos_TransactionType) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdatePos_TransactionType", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_TransactionTypeID", SqlDbType.Int).Value = pos_TransactionType.Pos_TransactionTypeID; cmd.Parameters.Add("@TransactionTypeName", SqlDbType.NVarChar).Value = pos_TransactionType.TransactionTypeName; cmd.Parameters.Add("@CentralStockFormula", SqlDbType.NChar).Value = pos_TransactionType.CentralStockFormula; cmd.Parameters.Add("@ShowRoomFormula", SqlDbType.NChar).Value = pos_TransactionType.ShowRoomFormula; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField3; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
protected void btnReceived_Click(object sender, EventArgs e) { int Pos_TransactionMasterID = int.Parse(Request.QueryString["Pos_TransactionMasterID"]); Pos_TransactionMaster pos_TransactionMaster = Pos_TransactionMasterManager.GetPos_TransactionMasterByID(Pos_TransactionMasterID); Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(pos_TransactionMaster.Pos_TransactionTypeID); string sql = "Declare @Count int; "; sql += "update Pos_TransactionMaster set ExtraField5='' where Pos_TransactionMasterID=" + Pos_TransactionMasterID + ";"; List <Pos_Product> items = new List <Pos_Product>(); items = Pos_ProductManager.GetAllPos_ProductsByTrasactionMasterID(Pos_TransactionMasterID); //updated by is the transaction ID string accountingEntry = ""; accountingEntry += @" Declare @JournalMasterID int Declare @ProductID int Declare @FinishedGoodsAmount decimal(18,2) INSERT INTO [ACC_JournalMaster] ([JournalMasterName] ,[ExtraField1] ,[ExtraField2] ,[ExtraField3] ,[Note] ,[JournalDate] ,[AddedBy] ,[AddedDate] ,[UpdatedBy] ,[UpdatedDate] ,[RowStatusID]) VALUES ('1'--<JournalMasterName, nvarchar(50),> ,''--<ExtraField1, nvarchar(256),> ,'POS ISSUE'--<ExtraField2, nvarchar(256),> ,'" + Pos_TransactionMasterID.ToString() + @"'--<ExtraField3, nvarchar(256),> ,'" + pos_TransactionMaster.ToOrFromName + " " + "Chalan #: " + pos_TransactionMaster.TransactionID + @"'--<Note, nvarchar(256),> ,GETDATE()--<JournalDate, datetime,> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<AddedBy, int,> ,GETDATE()--<AddedDate, datetime,> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<UpdatedBy, int,> ,GETDATE()--<UpdatedDate, datetime,> ,1--<RowStatusID, int,> ); Set @JournalMasterID = SCOPE_IDENTITY(); "; foreach (Pos_Product pos_Transaction in items) { //Finished Good(Aseet) -- branch accountingEntry += @" Set @ProductID=(Select ProductID from Pos_Product where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @") set @FinishedGoodsAmount=(select ([Pos_Product].[FabricsCost] + [Pos_Product].[AccesoriesCost] + [Pos_Product].[Overhead]+[Pos_Product].[OthersCost]+[Pos_Product].[PurchasePrice]) from Pos_Product where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @") INSERT INTO [ACC_JournalDetail] ([JournalMasterID] ,[ACC_ChartOfAccountLabel4ID] ,[ACC_ChartOfAccountLabel3ID] ,[WorkStation] ,[Debit] ,[Credit] ,[ExtraField3] ,[ExtraField2] ,[ExtraField1] ,[AddedBy] ,[AddedDate] ,[UpdatedBy] ,[UpdatedDate] ,[RowStatusID]) VALUES (@JournalMasterID--<JournalMasterID, int,> ,@ProductID--<ACC_ChartOfAccountLabel4ID, int,> ,9--<ACC_ChartOfAccountLabel3ID, int,> ," + pos_TransactionMaster.ToOrFromID + @"--<WorkStation, int,> ,(@FinishedGoodsAmount *" + decimal.Parse(pos_Transaction.ExtraField1).ToString("0.00") + @")--<Debit, decimal(20,2),> ,0--<Credit, decimal(20,2),> ,'" + pos_Transaction.UpdatedBy + @"'--<ExtraField3, nvarchar(256),> ,'POS ISSUE'--<ExtraField2, nvarchar(256),> ,''--<ExtraField1, nvarchar(256),> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<AddedBy, int,> ,GETDATE()--<AddedDate, datetime,> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<UpdatedBy, int,> ,GETDATE()--<UpdatedDate, datetime,> ,1--<RowStatusID, int,> ) ; "; //Finished Good(Aseet) -- head office accountingEntry += @" Set @ProductID=(Select ProductID from Pos_Product where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @") set @FinishedGoodsAmount=(select ([Pos_Product].[FabricsCost] + [Pos_Product].[AccesoriesCost] + [Pos_Product].[Overhead]+[Pos_Product].[OthersCost]+[Pos_Product].[PurchasePrice]) from Pos_Product where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @") INSERT INTO [ACC_JournalDetail] ([JournalMasterID] ,[ACC_ChartOfAccountLabel4ID] ,[ACC_ChartOfAccountLabel3ID] ,[WorkStation] ,[Debit] ,[Credit] ,[ExtraField3] ,[ExtraField2] ,[ExtraField1] ,[AddedBy] ,[AddedDate] ,[UpdatedBy] ,[UpdatedDate] ,[RowStatusID]) VALUES (@JournalMasterID--<JournalMasterID, int,> ,@ProductID--<ACC_ChartOfAccountLabel4ID, int,> ,9--<ACC_ChartOfAccountLabel3ID, int,> ,1--<WorkStation, int,> ,0--<Debit, decimal(20,2),> ,(@FinishedGoodsAmount *" + decimal.Parse(pos_Transaction.ExtraField1).ToString("0.00") + @")--<Credit, decimal(20,2),> ,'" + pos_Transaction.UpdatedBy + @"'--<ExtraField3, nvarchar(256),> ,'POS ISSUE'--<ExtraField2, nvarchar(256),> ,''--<ExtraField1, nvarchar(256),> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<AddedBy, int,> ,GETDATE()--<AddedDate, datetime,> ," + pos_TransactionMaster.AddedBy.ToString() + @"--<UpdatedBy, int,> ,GETDATE()--<UpdatedDate, datetime,> ,1--<RowStatusID, int,> ) ; "; if (pos_TransactionMaster.ToOrFromID == 1 && transactionType.CentralStockFormula != "0") { //For head office Central Stock sql += "Update Pos_Product set ExtraField1 =(cast(ExtraField1 as decimal(10,2)) + ((" + transactionType.CentralStockFormula + ")*" + pos_Transaction.ExtraField1 + ")) where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + ";"; } else if (pos_TransactionMaster.ToOrFromID != 1 && transactionType.ShowRoomFormula != "0") { sql += @" set @Count= ( select COUNT(*) from Pos_WorkStationStock where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID=" + pos_TransactionMaster.ToOrFromID + @" ) if @Count = 0 BEGIN INSERT INTO [Pos_WorkStationStock] ([WorkStationID] ,[ProductID] ,[Stock]) VALUES(" + pos_TransactionMaster.ToOrFromID + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + pos_Transaction.ExtraField1 + @"); END ELSE BEGIN Update Pos_WorkStationStock set Stock += ((+1)*" + pos_Transaction.ExtraField1 + @") where WorkStationID=" + pos_TransactionMaster.ToOrFromID + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; END; "; } } //CommonManager.SQLExec(sql); CommonManager.SQLExec(sql + accountingEntry); Response.Redirect("DelivaryChalanPrint.aspx?Pos_TransactionMasterID=" + Pos_TransactionMasterID); }
public Pos_TransactionType GetPos_TransactionTypeFromReader(IDataReader reader) { try { Pos_TransactionType pos_TransactionType = new Pos_TransactionType ( (int)reader["Pos_TransactionTypeID"], reader["TransactionTypeName"].ToString(), reader["CentralStockFormula"].ToString(), reader["ShowRoomFormula"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString() ); try { pos_TransactionType.ExtraField4 = reader["ExtraField4"].ToString(); pos_TransactionType.ExtraField5 = reader["ExtraField5"].ToString(); pos_TransactionType.ExtraField6 = reader["ExtraField6"].ToString(); pos_TransactionType.Sorting = int.Parse(pos_TransactionType.ExtraField5); } catch (Exception ex) { pos_TransactionType.ExtraField4 =""; pos_TransactionType.ExtraField5 = ""; pos_TransactionType.ExtraField6 = ""; } return pos_TransactionType; } catch(Exception ex) { return null; } }
public bool UpdatePos_TransactionType(Pos_TransactionType pos_TransactionType) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdatePos_TransactionType", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_TransactionTypeID", SqlDbType.Int).Value = pos_TransactionType.Pos_TransactionTypeID; cmd.Parameters.Add("@TransactionTypeName", SqlDbType.NVarChar).Value = pos_TransactionType.TransactionTypeName; cmd.Parameters.Add("@CentralStockFormula", SqlDbType.NChar).Value = pos_TransactionType.CentralStockFormula; cmd.Parameters.Add("@ShowRoomFormula", SqlDbType.NChar).Value = pos_TransactionType.ShowRoomFormula; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_TransactionType.ExtraField3; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public static int InsertPos_TransactionType(Pos_TransactionType pos_TransactionType) { SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); return sqlPos_TransactionTypeProvider.InsertPos_TransactionType(pos_TransactionType); }
public static int InsertPos_TransactionType(Pos_TransactionType pos_TransactionType) { SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); return(sqlPos_TransactionTypeProvider.InsertPos_TransactionType(pos_TransactionType)); }
protected void btnSubmit_Click(object sender, EventArgs e) { int transactionTypeID = int.Parse(Request.QueryString["TransactionTypeID"]); int TransactionMasterID = 0; bool IsIssueReturn = false; bool isTransferToanotherShowroom = false; bool isAdjustment = false; string Pending = "Pending"; switch (transactionTypeID) { case 10: //Issue Return IsIssueReturn = true; break; case 11: //Transfer to another showroom isTransferToanotherShowroom = true; break; case 23: //Adjustment + isAdjustment = true; Pending = ""; break; case 24: //Adjustment + isAdjustment = true; Pending = ""; break; default: break; } if (txtOldTransactionID.Text != "") { if (txtOldTransactionID.Text != "0") { TransactionMasterID = int.Parse(GetTransactionMasterID()); } else { TransactionMasterID = int.Parse(txtOldTransactionID.Text); } if (TransactionMasterID == 0) { showAlartMessage("Wrong old ID"); return; } } else { Pos_TransactionMaster pos_TransactionMaster = new Pos_TransactionMaster(); Pos_TransactionMaster pos_TransactionMasterOposite = new Pos_TransactionMaster(); pos_TransactionMaster.TransactionDate = DateTime.Parse(txtDate.Text); pos_TransactionMaster.TransactionID = 0; pos_TransactionMaster.Pos_TransactionTypeID = transactionTypeID; pos_TransactionMaster.ToOrFromID = (isAdjustment?int.Parse(ddlWorkStationSearch.SelectedValue): int.Parse(ddlWorkStation.SelectedValue)); pos_TransactionMaster.Record = ""; pos_TransactionMaster.Particulars = ""; pos_TransactionMaster.WorkSatationID = int.Parse(ddlWorkStationSearch.SelectedValue); pos_TransactionMaster.ExtraField1 = ""; pos_TransactionMaster.ExtraField2 = ""; pos_TransactionMaster.ExtraField3 = ""; pos_TransactionMaster.ExtraField4 = ""; pos_TransactionMaster.ExtraField5 = Pending; pos_TransactionMaster.AddedBy = getLogin().LoginID; pos_TransactionMaster.AddedDate = DateTime.Now; pos_TransactionMaster.UpdatedBy = getLogin().LoginID; pos_TransactionMaster.UpdatedDate = DateTime.Now; pos_TransactionMaster.RowStatusID = 1; if (isTransferToanotherShowroom) { TransactionMasterID = Pos_TransactionMasterManager.InsertPos_TransactionMaster(pos_TransactionMaster, true); } else { TransactionMasterID = Pos_TransactionMasterManager.InsertPos_TransactionMaster(pos_TransactionMaster); } pos_TransactionMaster = Pos_TransactionMasterManager.GetPos_TransactionMasterByID(TransactionMasterID); txtOldTransactionID.Text = pos_TransactionMaster.TransactionID.ToString(); } string sql = "Declare @Count int; "; foreach (GridViewRow gvr in gvPos_Product.Rows) { HiddenField hfPos_ProductID = (HiddenField)gvr.FindControl("hfPos_ProductID"); TextBox txtQty = (TextBox)gvr.FindControl("txtQty"); if (txtQty.Text == "") { continue; } if (decimal.Parse(txtQty.Text) == 0) { continue; } Pos_Transaction pos_Transaction = new Pos_Transaction(); pos_Transaction.Pos_ProductID = Int32.Parse(hfPos_ProductID.Value); pos_Transaction.Quantity = Decimal.Parse(txtQty.Text); pos_Transaction.Pos_ProductTrasactionTypeID = transactionTypeID; pos_Transaction.Pos_ProductTransactionMasterID = TransactionMasterID; pos_Transaction.WorkStationID = Int32.Parse(ddlWorkStationSearch.SelectedValue); pos_Transaction.ExtraField1 = ""; pos_Transaction.ExtraField2 = ""; pos_Transaction.ExtraField3 = ""; pos_Transaction.ExtraField4 = ""; pos_Transaction.ExtraField5 = ""; pos_Transaction.AddedBy = getLogin().LoginID; pos_Transaction.AddedDate = DateTime.Now; pos_Transaction.UpdatedBy = getLogin().LoginID; pos_Transaction.UpdatedDate = DateTime.Now; pos_Transaction.RowStatusID = 1; if (isTransferToanotherShowroom) { Pos_TransactionManager.InsertPos_TransactionWithOpositeEntry(pos_Transaction); } else { Pos_TransactionManager.InsertPos_Transaction(pos_Transaction); } if (IsIssueReturn) { Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(transactionTypeID); if (transactionType.CentralStockFormula != "0") { //sql += "Update Pos_Product set ExtraField1 =(cast(ExtraField1 as decimal(10,2)) + ((" + transactionType.CentralStockFormula + ")*" + txtQty.Text + ")) where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + ";"; } if (transactionType.ShowRoomFormula != "0") { sql += @" set @Count= ( select COUNT(*) from Pos_WorkStationStock where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" ) if @Count = 0 BEGIN INSERT INTO [Pos_WorkStationStock] ([WorkStationID] ,[ProductID] ,[Stock]) VALUES(" + ddlWorkStationSearch.SelectedValue + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + txtQty.Text + @"); END ELSE BEGIN Update Pos_WorkStationStock set Stock += ((" + transactionType.ShowRoomFormula + @")*" + txtQty.Text + @") where WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; END;"; } } if (isTransferToanotherShowroom) { Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(transactionTypeID); if (transactionType.ShowRoomFormula != "0") { sql += @"/* set @Count= ( select COUNT(*) from Pos_WorkStationStock where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" ) if @Count = 0 BEGIN INSERT INTO [Pos_WorkStationStock] ([WorkStationID] ,[ProductID] ,[Stock]) VALUES(" + ddlWorkStationSearch.SelectedValue + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + txtQty.Text + @"); END ELSE BEGIN Update Pos_WorkStationStock set Stock += ((+1)*" + txtQty.Text + @") where WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; END; */ Update Pos_WorkStationStock set Stock += ((-1)*" + txtQty.Text + @") where WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; "; } } if (isAdjustment) { Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(transactionTypeID); if (transactionType.ShowRoomFormula != "0") { sql += @" set @Count= ( select COUNT(*) from Pos_WorkStationStock where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" ) if @Count = 0 BEGIN INSERT INTO [Pos_WorkStationStock] ([WorkStationID] ,[ProductID] ,[Stock]) VALUES(" + ddlWorkStationSearch.SelectedValue + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + txtQty.Text + @"); END ELSE BEGIN Update Pos_WorkStationStock set Stock += ((" + (transactionTypeID == 23?"":"-") + @"1)*" + txtQty.Text + @") where WorkStationID=" + ddlWorkStationSearch.SelectedValue + @" and ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; END; "; } } } CommonManager.SQLExec(sql); btnSearch_Click(this, new EventArgs()); hlnkProductionPrint.Visible = true; hlnkProductionPrint.NavigateUrl = "TransactionPrint.aspx?Pos_TransactionMasterID=" + TransactionMasterID.ToString(); doSearch(true); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (ddlWorkStation.SelectedValue == "0") { showAlartMessage("Please select the Work Station"); return; } if (Request.QueryString["TransactionTypeID"] == "15") { ddlWorkStation.SelectedValue = "1"; if (ddlRefference.SelectedValue == "0") { showAlartMessage("Please select the Work Station or Ref"); return; } } if (gvPos_Product.Rows.Count == 0) { showAlartMessage("Plz add some product"); return; } foreach (GridViewRow gvr in gvPos_Product.Rows) { Label lblBarCode = (Label)gvr.FindControl("lblBarCode"); TextBox txtQty = (TextBox)gvr.FindControl("txtQty"); Label lblStock = (Label)gvr.FindControl("lblStock"); if (decimal.Parse(lblStock.Text) < decimal.Parse(txtQty.Text)) { showAlartMessage(lblBarCode.Text + " is going to issue more than stock. pleae enter the correct value"); return; } } btnSubmit.Visible = false; int transactionTypeID = int.Parse(Request.QueryString["TransactionTypeID"]); int TransactionMasterID = 0; if (txtOldTransactionID.Text != "") { if (txtOldTransactionID.Text != "0") { TransactionMasterID = int.Parse(GetTransactionMasterID()); } else { TransactionMasterID = int.Parse(txtOldTransactionID.Text); } if (TransactionMasterID == 0) { showAlartMessage("Wrong old ID"); return; } } else { Pos_TransactionMaster pos_TransactionMaster = new Pos_TransactionMaster(); pos_TransactionMaster.TransactionDate = DateTime.Parse(txtDate.Text); pos_TransactionMaster.TransactionID = 0; pos_TransactionMaster.Pos_TransactionTypeID = transactionTypeID; pos_TransactionMaster.ToOrFromID = int.Parse(ddlWorkStation.SelectedValue); pos_TransactionMaster.Record = ""; pos_TransactionMaster.Particulars = ""; pos_TransactionMaster.WorkSatationID = 1; pos_TransactionMaster.ExtraField1 = ""; pos_TransactionMaster.ExtraField2 = ""; pos_TransactionMaster.ExtraField3 = ""; pos_TransactionMaster.ExtraField4 = ""; pos_TransactionMaster.ExtraField5 = (transactionTypeID == 9? "Pending":""); pos_TransactionMaster.AddedBy = getLogin().LoginID; pos_TransactionMaster.AddedDate = DateTime.Now; pos_TransactionMaster.UpdatedBy = getLogin().LoginID; pos_TransactionMaster.UpdatedDate = DateTime.Now; pos_TransactionMaster.RowStatusID = 1; TransactionMasterID = Pos_TransactionMasterManager.InsertPos_TransactionMaster(pos_TransactionMaster); pos_TransactionMaster = Pos_TransactionMasterManager.GetPos_TransactionMasterByID(TransactionMasterID); txtOldTransactionID.Text = pos_TransactionMaster.TransactionID.ToString(); } string sql = "Declare @Count int; "; foreach (GridViewRow gvr in gvPos_Product.Rows) { HiddenField hfPos_ProductID = (HiddenField)gvr.FindControl("hfPos_ProductID"); TextBox txtQty = (TextBox)gvr.FindControl("txtQty"); Label lblStock = (Label)gvr.FindControl("lblStock"); if (txtQty.Text == "") { continue; } if (decimal.Parse(txtQty.Text) == 0) { continue; } if (decimal.Parse(lblStock.Text) < decimal.Parse(txtQty.Text)) { txtQty.Text = lblStock.Text; } Pos_Transaction pos_Transaction = new Pos_Transaction(); pos_Transaction.Pos_ProductID = Int32.Parse(hfPos_ProductID.Value); pos_Transaction.Quantity = Decimal.Parse(txtQty.Text); pos_Transaction.Pos_ProductTrasactionTypeID = transactionTypeID; pos_Transaction.Pos_ProductTransactionMasterID = TransactionMasterID; pos_Transaction.WorkStationID = Int32.Parse(ddlWorkStation.SelectedValue); pos_Transaction.ExtraField1 = ""; pos_Transaction.ExtraField2 = ""; pos_Transaction.ExtraField3 = ""; pos_Transaction.ExtraField4 = ""; pos_Transaction.ExtraField5 = ""; pos_Transaction.AddedBy = getLogin().LoginID; pos_Transaction.AddedDate = DateTime.Now; pos_Transaction.UpdatedBy = getLogin().LoginID; pos_Transaction.UpdatedDate = DateTime.Now; pos_Transaction.RowStatusID = 1; int resutl = Pos_TransactionManager.InsertPos_Transaction(pos_Transaction); bool IsGeneralOperation = false; //accounts need to update switch (transactionTypeID) { case 9: //Issue IsGeneralOperation = true; break; case 5: //Adjustment - IsGeneralOperation = true; break; case 6: //Adjustment + IsGeneralOperation = true; break; default: break; } if (IsGeneralOperation) { Pos_TransactionType transactionType = Pos_TransactionTypeManager.GetPos_TransactionTypeByID(transactionTypeID); if (transactionType.CentralStockFormula != "0") { sql += "Update Pos_Product set ExtraField1 =(cast(ExtraField1 as decimal(10,2)) + ((" + transactionType.CentralStockFormula + ")*" + txtQty.Text + ")) where Pos_ProductID=" + pos_Transaction.Pos_ProductID.ToString() + ";"; } /* * Any thing will be send to another place need the accepting from the receiver * if (transactionType.ShowRoomFormula != "0") * { * sql += @" * set @Count= * ( * select COUNT(*) from Pos_WorkStationStock * where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @" and WorkStationID="+ddlWorkStation.SelectedValue+@" * ) * * if @Count = 0 * BEGIN * INSERT INTO [Pos_WorkStationStock] * ([WorkStationID] * ,[ProductID] * ,[Stock]) * VALUES(" + ddlWorkStation.SelectedValue + @"," + pos_Transaction.Pos_ProductID.ToString() + @"," + txtQty.Text + @"); * END * ELSE * BEGIN * Update Pos_WorkStationStock set Stock += ((" + transactionType.ShowRoomFormula + @")*" + txtQty.Text + @") where ProductID=" + pos_Transaction.Pos_ProductID.ToString() + @"; * END;"; * } */ } } saveForRemoteDatabase(TransactionMasterID); CommonManager.SQLExec(sql); btnSearch_Click(this, new EventArgs()); hlnkProductionPrint.Visible = true; hlnkProductionPrint.NavigateUrl = (Request.QueryString["TransactionTypeID"] == "9" ? "DelivaryChalanPrint" : "TransactionPrint") + ".aspx?Pos_TransactionMasterID=" + TransactionMasterID.ToString(); }
public static bool UpdatePos_TransactionType(Pos_TransactionType pos_TransactionType) { SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); return(sqlPos_TransactionTypeProvider.UpdatePos_TransactionType(pos_TransactionType)); }
public static bool UpdatePos_TransactionType(Pos_TransactionType pos_TransactionType) { SqlPos_TransactionTypeProvider sqlPos_TransactionTypeProvider = new SqlPos_TransactionTypeProvider(); return sqlPos_TransactionTypeProvider.UpdatePos_TransactionType(pos_TransactionType); }