//public CResult ReadByBranchAndDate(string BranchCode, DateTime FromDate, DateTime ToDate)
//{
// List<CGRDetails> oItemList = new List<CGRDetails>();
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// try
// {
// DataSet ds = new DataSet();
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.CommandText = "sp_GRDetail_ReadByBrnIdAndDate";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@BranchID", BranchCode);
// cmd.Parameters.AddWithValue("@SOMstr_DateFrom", FromDate);
// cmd.Parameters.AddWithValue("@SOMstr_DateTo", ToDate);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// da.Fill(ds);
// DataTable dtItem = ds.Tables[0];
// // oItemList.Add("");
// foreach (DataRow dr in dtItem.Rows)
// {
// CGRDetails oGRDetails = new CGRDetails();
// oGRDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString();
// oGRDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString());
// oGRDetails.GRDet_BranchOID = dr["GRDet_Branch"].ToString();
// oGRDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString());
// oGRDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString());
// oGRDetails.GRDet_ItemName = dr["GRDet_ItemName"].ToString();
// oItemList.Add(oGRDetails);
// }
// oResult.IsSuccess = true;
// oResult.Data = oItemList;
// }
// catch (SqlException e)
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = e.Message;
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
//public CResult ReduceByItemOID(List<CSODetails> oListSODetails)
//{
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.Transaction = oConnManager.BeginTransaction();
// try
// {
// foreach (CSODetails oSODetails in oListSODetails)
// {
// cmd.CommandText = "sp_GRDetails_ReduceByItemOID";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@ItemOID", oSODetails.SODet_ItemOID);
// cmd.Parameters.AddWithValue("@ItemQTY", oSODetails.SODet_QTY);
// cmd.Parameters.AddWithValue("@BranchOID", oSODetails.SODet_BranchOID);
// cmd.ExecuteNonQuery();
// }
// oConnManager.Commit();
// oResult.IsSuccess = true;
// }
// catch (SqlException e)
// {
// string sRollbackError = oConnManager.Rollback();
// oResult.IsSuccess = false;
// oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
public CResult ExportAndUpdate(CGRMaster oMaster, string url)
{
CInventory oInventory = new CInventory();
CResult oResult = new CResult();
DataTable dt = new DataTable();
List <CInventory> oInvtList = new List <CInventory>();
List <CGRDetails> exportExcelList = new List <CGRDetails>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oDetails.GRDet_LocOID;
oInventory.Invt_QTY = oDetails.GRDet_QTY;
oInvtList.Add(oInventory);
exportExcelList.Add(oDetails);
}
CsvExport <CGRDetails> csv = new CsvExport <CGRDetails>(exportExcelList);
//csv.Export();
// csv.ExportToFile(url);
// InventoryDT = ConvertToDataTable<CGRDetails>(exportExcelList);
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtDecInt(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
