//public List<CHijibi> amount(string uID)
//{
// List<CHijibi> oamount =new List<CHijibi>();
// DataTable oDt = null;
// strSQL = "select * from t_Mozila";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// if (oDt != null)
// {
// foreach (DataRow dr in oDt.Rows)
// {
// CHijibi oamounta = new CHijibi();
// oamounta.Chrom = float.Parse(dr["Chrom"].ToString());
// oamount.Add(oamounta);
// oamounta = null;
// }
// }
// return oamount;
//}
//public CSalesproduct CreateMaxID(string uID)
//{
// string MasterID = string.Empty;
// DataTable oDt = null;
// try
// {
// strSQL = string.Format("SELECT SOMstr_OID FROM t_SOMstr ");
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// if (oDt != null)
// {
// if (oDt.Rows.Count == 0)//BIL-NO-00001
// {
// MasterID = "SOMstrXXBRN01 0000000001";
// }
// else
// {
// DataRow dr = oDt.Rows[0];
// MasterID = dr["Bill_Id"].ToString();
// MasterID = MasterID.Remove(0, 13);
// MasterID = (Convert.ToInt64(MasterID) + 1).ToString();
// MasterID = MasterID.PadLeft(2, '0');
// MasterID = MasterID.PadLeft(3, '0');
// MasterID = MasterID.PadLeft(4, '0');
// MasterID = MasterID.PadLeft(5, '0');
// MasterID = MasterID.PadLeft(6, '0');
// MasterID = MasterID.PadLeft(7, 'O');
// MasterID = MasterID.PadLeft(8, '0');
// MasterID = MasterID.PadLeft(9, '0');
// MasterID = MasterID.PadLeft(10, '0');
// MasterID = MasterID.PadLeft(11, ' ');
// MasterID = MasterID.PadLeft(12, '1');
// MasterID = MasterID.PadLeft(13, '0');
// MasterID = MasterID.PadLeft(14, 'N');
// MasterID = MasterID.PadLeft(15, 'R');
// MasterID = MasterID.PadLeft(16, 'B');
// MasterID = MasterID.PadLeft(17, 'X');
// MasterID = MasterID.PadLeft(18, 'X');
// MasterID = MasterID.PadLeft(19, 'r');
// MasterID = MasterID.PadLeft(20, 't');
// MasterID = MasterID.PadLeft(21, 's');
// MasterID = MasterID.PadLeft(22, 'M');
// MasterID = MasterID.PadLeft(23, 'O');
// MasterID = MasterID.PadLeft(23, 'S');
// }
// }
// }
// catch (Exception ex)
// {
// oManager.s_ErrorMessage = ex.Message;
// MasterID = string.Empty;
// }
// finally
// {
// oManager = null;
// strSQL = string.Empty;
// }
// return null;
//}
public CSalesDetials DeleteFromdetails(string ItemID, string So_detailsID, float qty, string receiveID, string MasterID, float detamount, string uID)
{
CSalesDetials oSaleaDetails = new CSalesDetials();
DataTable oDt = null;
try
{
strSQL = "delete from t_SODet where SODet_OID='" + So_detailsID + "'";
//strSQL = @"IF(EXISTS(SELECT ID FROM t_SODet WHERE SODet_ItemOID='" + Rec_OID + "'))BEGIN UPDATE t_GReceive SET Rec_ReceivedQty=Rec_ReceivedQty-" + oSaleaDetails.SODet_QTY + "where Rec_ProductID='" + Rec_OID + "' END";
//sqlList.Add(strSQL);
oManager = new CConManager();
oDt = oManager.Read(strSQL);
strSQL = string.Empty;
strSQL = "Update t_GReceive set Rec_ReceivedQty=Rec_ReceivedQty- " + qty + " where Rec_OID='" + receiveID + "' and Rec_ProductID = '" + ItemID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
strSQL = string.Empty;
strSQL = "Update t_SOMstr set SOMstr_NetAmt=SOMstr_NetAmt- " + detamount + " where SOMstr_OID='" + MasterID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
//float deletedAmount = Actualamount - amount;
// float percentage = (deletedAmount * 100) / Actualamount;
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oSaleaDetails);
}
public List <CSalesDetials> Saleadetels(string SODet_MStrOID, string uID)
{
List <CSalesDetials> oSalesDetails = new List <CSalesDetials>();
DataTable oDt = null;
try
{ //SELECT dbo.t_Item.Item_ItemName, dbo.t_SODet.* FROM dbo.t_Item LEFT OUTER JOIN dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID
strSQL = @"SELECT dbo.t_SODet.SODet_OID, dbo.t_SODet.SODet_Branch, dbo.t_SODet.SODet_MStrOID, dbo.t_SODet.SODet_ItemSLNum, dbo.t_SODet.SODet_ItemOID,
dbo.t_SODet.SODet_QTY, dbo.t_SODet.SODet_UOM, dbo.t_SODet.SODet_Price, dbo.t_SODet.SODet_Currency, dbo.t_SODet.SODet_Amount,
dbo.t_SODet.SODet_SDValue, dbo.t_SODet.SODet_SDAmount, dbo.t_SODet.SODet_VATValue, dbo.t_SODet.SODet_VATAmount, dbo.t_SODet.SODet_Discount,
dbo.t_SODet.SODet_NetAmount, dbo.t_SODet.SODet_BranchOID, dbo.t_SODet.SODet_LocOID, dbo.t_GReceive.Rec_ReceivedQty, dbo.t_GReceive.Rec_IssueQTY,
dbo.t_GReceive.Rec_WantedQTY, dbo.t_GReceive.Rec_ProductID, dbo.t_GReceive.Rec_OID, dbo.t_GReceive.Rec_BranchID, dbo.t_Item.Item_ItemName
FROM dbo.t_Item LEFT OUTER JOIN
dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID LEFT OUTER JOIN
dbo.t_GReceive ON dbo.t_SODet.SODet_ItemOID = dbo.t_GReceive.Rec_ProductID where SODet_MStrOID= '" + SODet_MStrOID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
if (oDt.Rows.Count > 0)
{
foreach (DataRow dr in oDt.Rows)
{
CSalesDetials salesDetails = new CSalesDetials();
salesDetails.SODet_OID = dr["SODet_OID"].ToString();
salesDetails.SODet_MStrOID = dr["SODet_MStrOID"].ToString();
salesDetails.SODet_ItemName = dr["Item_ItemName"].ToString();
salesDetails.SODet_Branch = dr["SODet_Branch"].ToString();
//salesDetails.SODet_ItemSLNum = dr["SODet_ItemSLNum"].ToString();
salesDetails.SODet_ItemOID = dr["SODet_ItemOID"].ToString();
//salesDetails.SODet_ItemName = dr["SODet_ItemName"].ToString();
salesDetails.SODet_QTY = float.Parse(dr["SODet_QTY"].ToString());
//salesDetails.SODet_UOM = dr["SODet_UOM"].ToString();
salesDetails.SODet_Price = float.Parse(dr["SODet_Price"].ToString());
//salesDetails.SODet_Currency = dr["SODet_Currency"].ToString();
salesDetails.SODet_Amount = float.Parse(dr["SODet_Amount"].ToString());
salesDetails.SODet_SDValue = float.Parse(dr["SODet_SDValue"].ToString());
salesDetails.SODet_SDAmount = float.Parse(dr["SODet_SDAmount"].ToString());
salesDetails.SODet_VATValue = float.Parse(dr["SODet_VATValue"].ToString());
salesDetails.SODet_VATAmount = float.Parse(dr["SODet_VATAmount"].ToString());
salesDetails.SODet_Discount = float.Parse(dr["SODet_Discount"].ToString());
salesDetails.SODet_NetAmount = float.Parse(dr["SODet_NetAmount"].ToString());
salesDetails.Rec_OID = dr["Rec_OID"].ToString();
//salesDetails.SODet_LocOID = dr["SODet_LocOID"].ToString();
oSalesDetails.Add(salesDetails);
salesDetails = null;
}
}
//else
//{
// strSQL = @"delete from t_SOMstr where SOMstr_OID = '" + SODet_MStrOID + "'";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
//}
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oSalesDetails);
}
