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);
}
