void oSearch_SelectedEvent(object sender, SearchEventArgs <CGRMaster> e)
{
FormControlMode(1);
CGRMaster oMTMaster = e.t;
FillForm(oMTMaster);
}
private CGRMaster GetResultSetToGRMaster(DataRow dr)
{
CGRMaster oGRMaster = new CGRMaster();
oGRMaster.GRMstr_OID = dr["GRMstr_OID"].ToString();
oGRMaster.GRMstr_Branch = dr["GRMstr_Branch"].ToString();
oGRMaster.GRMstr_Code = dr["GRMstr_Code"].ToString();
oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString()).Date;
oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString());
oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString();
oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString();
oGRMaster.GRMstr_VendorID = dr["GRMstr_VendorID"].ToString();
oGRMaster.GRMstr_TotalAmt = float.Parse(dr["GRMstr_TotalAmt"].ToString());
oGRMaster.Creator = dr["GRMstr_Creator"].ToString();
oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString()).Date;
oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString();
oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString()).Date;
oGRMaster.IsActive = dr["GRMstr_IsActive"].ToString();
oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString();
return(oGRMaster);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ValidationData())
{
CResult oResult = new CResult();
CGRBO oGRBO = new CGRBO();
CGRMaster oMaster = GetToBSavedData();
if (oMaster != null)
{
if (!IsUpdateMode)
{
oResult = oGRBO.Create(oMaster);
}
else
{
oResult = oGRBO.Update(oMaster, oGRFinalQtyDic);
}
if (oResult.IsSuccess)
{
MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFormData();
GetGRNextCode();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private CGRMaster LoadImportedData(CMTMaster oMTMaster)
{
CGRMaster oGRMaster = new CGRMaster();
oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Branch;
oGRMaster.GRMstr_By = currentUser.User_OID;
oGRMaster.GRMstr_RefBy = oMTMaster.MTMstr_DOrder;
oGRMaster.GRMstr_Type = 0;
oGRMaster.Creator = currentUser.User_OID;
oGRMaster.CreationDate = DateTime.Now.Date;
foreach (CMTDetails oMTDetails in oMTMaster.MTMstr_DetailsList)
{
CGRDetails oGRDetails = new CGRDetails();
oGRDetails.GRDet_ItemOID = oMTDetails.MTDtls_ItemOID;
oGRDetails.GRDet_QTY = oMTDetails.MTDtls_IssQty;
oGRDetails.GRDet_UOM = oMTDetails.MTDtls_IssUOMOID;
oGRDetails.GRDet_LocOID = oMTDetails.MTDtls_DestLocOID;
oGRDetails.GRDet_InvType = oMTDetails.MTDtls_DesInvtyp;
oGRMaster.GRMstr_DetailsList.Add(oGRDetails);
}
return(oGRMaster);
}
private void FillForm(CGRMaster oGRMaster)
{
oGRExistingQtyDic.Clear();
txtSelectedGROID.Text = oGRMaster.GRMstr_OID;
txtGRNo.Text = oGRMaster.GRMstr_Code;
ddlType.SelectedValue = oGRMaster.GRMstr_Type;
dtpGRDate.Value = oGRMaster.GRMstr_Date;
txtRecievedBy.Text = oGRMaster.GRMstr_By;
txtRemarks.Text = oGRMaster.Remarks;
ddlSupplier.SelectedValue = oGRMaster.GRMstr_VendorID;
txtRefNo.Text = oGRMaster.GRMstr_RefBy;
dgItemList.Rows.Clear();
foreach (CGRDetails oGRDetails in oGRMaster.GRMstr_DetailsList)
{
dgItemList.Rows.Add();
DataGridViewRow odgRow = dgItemList.Rows[dgItemList.Rows.Count - 2];
odgRow.Cells["colItemName"].Value = oGRDetails.GRDet_ItemOID.Trim();
odgRow.Cells["colIssueqty"].Value = oGRDetails.GRDet_QTY.ToString();
odgRow.Cells["colIssueUOM"].Value = oGRDetails.GRDet_UOM.Trim();
odgRow.Cells["colSourceLoc"].Value = oGRDetails.GRDet_LocOID.Trim();
odgRow.Cells["colSrcInvType"].Value = Enum.GetName(typeof(EInvType), oGRDetails.GRDet_InvType);
odgRow.Cells["colPrice"].Value = oGRDetails.GRDet_Price.ToString("F2").Trim();
if (oGRDetails.GRDet_Currency.Trim() != "")
{
odgRow.Cells["colCurrency"].Value = oGRDetails.GRDet_Currency.Trim();
}
odgRow.Cells["colAmount"].Value = oGRDetails.GRDet_Amount.ToString("F2").Trim();
//odgRow.Cells["NowQty"].Value = oGRDetails.GRdet_InvQ.ToString();
if (IsUpdateMode)
{
oGRExistingQtyDic.Add(oGRDetails.GRDet_ItemOID.Trim(), oGRDetails);
// odgRow.Cells["colInvtQty"].Value = oGRDetails.GRDet_QTY.ToString("F2");
}
}
CalculateTotal();
}
//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.InvtDec(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);
}
public CResult Update(CGRMaster oMaster, Dictionary <string, CGRDetails> oGRFinalQtyDic)
{
List <CInventory> oInvtList = new List <CInventory>();
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
{
cmd.CommandText = "sp_GRMaster_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID);
cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch);
cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code);
cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date);
cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type);
cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By);
cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy);
cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID);
cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt);
cmd.Parameters.AddWithValue("@Creator", oMaster.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0);
cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks);
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete from t_GRDet where GRDet_MStrOID=@GRMstr_OID";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID);
cmd.ExecuteNonQuery();
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
cmd.CommandText = "sp_GRDetails_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch);
cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID);
cmd.Parameters.AddWithValue("@GRDet_MStrOID", oMaster.GRMstr_OID);
cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID);
cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY);
cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM);
cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID);
cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID);
cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType);
cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price);
cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency);
cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount);
cmd.ExecuteNonQuery();
}
// update inventory
foreach (CGRDetails oGRDetails in oGRFinalQtyDic.Values)
{
// populate inv list
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oGRDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oGRDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oGRDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oGRDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oGRDetails.GRDet_LocOID;
oInventory.Invt_QTY = oGRDetails.GRDet_QTY;
oInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtInc(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);
}
public CResult Create(CGRMaster oMaster)
{
List <CInventory> oInvtList = new List <CInventory>();
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
{
//
cmd.CommandText = "sp_GRMaster_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GRMstr_OID", SqlDbType.Char, 24);
cmd.Parameters["@GRMstr_OID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch);
cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code);
cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date);
cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type);
cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By);
cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy);
cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID);
cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt);
cmd.Parameters.AddWithValue("@Creator", oMaster.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0);
cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks);
cmd.Parameters.AddWithValue("@IsImported", oMaster.GRMstr_IsImported);
cmd.ExecuteNonQuery();
string stGRMStr_OID = cmd.Parameters["@GRMstr_OID"].Value.ToString();
if (stGRMStr_OID.Trim() == "")
{
oResult.ErrMsg = "This delivered data is already exists.";
oResult.IsSuccess = false;
return(oResult);
}
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
cmd.CommandText = "sp_GRDetails_Insert";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch);
cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID);
cmd.Parameters.AddWithValue("@GRDet_MStrOID", stGRMStr_OID);
cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID);
cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY);
cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM);
cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID);
cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID);
cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType);
cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price);
cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency);
cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount);
cmd.ExecuteNonQuery();
// populate inv list
CInventory 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);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtInc(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);
}
public CResult ReadByIDDate(DateTime dtFrom, DateTime dtTo, string sID, string stCond)
{
List <CGRDetails> oGRDetailsList = new List <CGRDetails>();
List <CGRMaster> oGRMasterList = new List <CGRMaster>();
CResult oResult = new CResult();
oResult.IsSuccess = false;
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da;
DataSet ds;
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_GRMaster_ReadByIDDate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
if (sID == null)
{
cmd.Parameters.AddWithValue("@frmDate", dtFrom);
cmd.Parameters.AddWithValue("@toDate", dtTo);
cmd.Parameters.AddWithValue("@OID", DBNull.Value);
cmd.Parameters.AddWithValue("@Cond", int.Parse(stCond));
}
else
{
cmd.Parameters.AddWithValue("@frmDate", dtFrom);
cmd.Parameters.AddWithValue("@toDate", dtTo);
cmd.Parameters.AddWithValue("@OID", sID);
cmd.Parameters.AddWithValue("@Cond", int.Parse(stCond));
}
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
if (ds.Tables.Count > 0)
{
DataTable dtMaster = ds.Tables[0] as DataTable;
DataTable dtDetails = ds.Tables[1] as DataTable;
foreach (DataRow dr in dtDetails.Rows)
{
oGRDetailsList.Add(GetResultSetToGRDetails(dr));
}
foreach (DataRow dr in dtMaster.Rows)
{
CGRMaster oGRMaster = new CGRMaster();
oGRMaster = GetResultSetToGRMaster(dr);
foreach (CGRDetails oGRDetails in oGRDetailsList)
{
if (oGRDetails.GRDet_MStrOID == oGRMaster.GRMstr_OID)
{
oGRMaster.GRMstr_DetailsList.Add(oGRDetails);
}
}
oGRMasterList.Add(oGRMaster);
}
}
oResult.IsSuccess = true;
oResult.Data = oGRMasterList;
oConnManager.Commit();
}
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);
}
private void btnImport_Click(object sender, EventArgs e)
{
try
{
progressBarImport.Value = 0;
Cursor = Cursors.WaitCursor;
string selectGRFromHomeMaster = "select *from t_GRMstr where GRMatr_IsImported=0";
SqlConnection oConnectionForHomeDB = new CConManager().GetConnectionForRemote();
DataTable dtHome = new DataTable();
SqlCommand oCommandForHome = new SqlCommand(selectGRFromHomeMaster, oConnectionForHomeDB);
oCommandForHome.CommandType = CommandType.Text;
SqlDataAdapter oSqlAdapter = new SqlDataAdapter(oCommandForHome);
oSqlAdapter.Fill(dtHome);
List <CGRMaster> oGRMasterList = new List <CGRMaster>();
progressBarImport.Value = 70;
if (dtHome.Rows.Count > 0)
{
progressBarImport.Value = 70;
foreach (DataRow dr in dtHome.Rows)
{
CGRMaster oGRMaster = new CGRMaster();
oGRMaster.GRMstr_OID = "";
oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code;
oGRMaster.GRMstr_Code = GetGRmstrCode();
oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString());
oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString());
oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString();
oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString();
oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString();
oGRMaster.Creator = dr["GRMstr_Creator"].ToString();
oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString());
oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString();
oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString());
oGRMaster.IsActive = "Y";
oGRMaster.GRMstr_IsImported = 1;
string selectGRForHomeDetail = "select *from t_GRDet where GRDet_MStrOID='" + dr["GRMstr_OID"].ToString() + "'";
SqlConnection oConnectionForHomeDBDetail = new CConManager().GetConnectionForRemote();
DataTable dtHomedetail = new DataTable();
SqlCommand oCommand = new SqlCommand(selectGRForHomeDetail, oConnectionForHomeDBDetail);
oCommand.CommandType = CommandType.Text;
SqlDataAdapter oDataAdapter = new SqlDataAdapter(oCommand);
oDataAdapter.Fill(dtHomedetail);
//List<CGRDetails> oGRDetailList = new List<CGRDetails>();
if (dtHomedetail.Rows.Count > 0)
{
foreach (DataRow drDetail in dtHomedetail.Rows)
{
CGRDetails oGRDetails = new CGRDetails();
oGRDetails.GRDet_Branch = currentBranch.CompBrn_Code;
oGRDetails.GRDet_ItemOID = drDetail["GRDet_ItemOID"].ToString();
oGRDetails.GRDet_QTY = float.Parse(drDetail["GRDet_QTY"].ToString());
oGRDetails.GRDet_UOM = drDetail["GRDet_UOM"].ToString();
oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId;
oGRDetails.GRDet_LocOID = drDetail["GRDet_LocOID"].ToString();
oGRDetails.GRDet_InvType = int.Parse(drDetail["GRDet_InvType"].ToString());
oGRDetails.GRDet_Price = float.Parse(drDetail["GRDet_Price"].ToString());
oGRDetails.GRDet_Currency = drDetail["GRDet_Currency"].ToString();
oGRDetails.GRDet_Amount = float.Parse(drDetail["GRDet_Amount"].ToString());
//oGRDetailList.Add(oGRDetails);
oGRMaster.GRMstr_DetailsList.Add(oGRDetails);
}
}
//oGRMaster.GRMstr_DetailsList = oGRDetailList;
oGRMasterList.Add(oGRMaster);
}
if (oGRMasterList.Count > 0)
{
foreach (CGRMaster oGRMaster in oGRMasterList)
{
progressBarImport.Value = 50;
CResult oResult = new CResult();
CGRBO oGRBO = new CGRBO();
if (oGRMaster != null)
{
oResult = oGRBO.Create(oGRMaster);
}
if (oResult.IsSuccess)
{
progressBarImport.Value = 100;
this.Cursor = Cursors.Default;
oResult = oGRBO.UpdateHomeGRTable();
}
progressBarImport.Value = 100;
MessageBox.Show("Goods are successfully Imported", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else if (dtHome.Rows.Count <= 0)
{
DialogResult oDR = MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (oDR.ToString() == "OK")
{
this.Cursor = Cursors.Default;
progressBarImport.Value = 0;
}
}
}
catch
{
MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private CGRMaster GetToBSavedDataExportBranch()
{
oGRFinalQtyDic.Clear();
CGRMaster oGRMaster = new CGRMaster();
oGRMaster.GRMstr_OID = txtSelectedGROID.Text.Trim();
oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code;//cmbBranch.SelectedItem.ToString();
oGRMaster.GRMstr_Code = txtGRNo.Text.Trim();
oGRMaster.GRMstr_Type = Convert.ToInt32(Enum.Parse(typeof(EGRType), ddlType.SelectedItem.ToString()));
oGRMaster.GRMstr_Date = dtpGRDate.Value.Date;
oGRMaster.GRMstr_By = txtRecievedBy.Text.Trim();
oGRMaster.Remarks = txtRemarks.Text.Trim();
if (currentBranch.CompBrn_OId == "CompBrnXBRN01 0000000001")
{
oGRMaster.GRMstr_IsImported = 0;
}
else if (currentBranch.CompBrn_OId != "CompBrnXBRN01 0000000001")
{
oGRMaster.GRMstr_IsImported = 1;
}
// oGRMaster.GRMstr_VendorID = ddlSupplier.SelectedValue.ToString();
oGRMaster.GRMstr_RefBy = txtRefNo.Text.Trim();
oGRMaster.Creator = currentUser.User_OID;
oGRMaster.CreationDate = DateTime.Now.Date;
oGRMaster.UpdateBy = currentUser.User_OID;
oGRMaster.UpdateDate = DateTime.Now.Date;
oGRMaster.IsActive = "Y";
oGRMaster.Remarks = "";
for (int i = 0; i < dgItemList.Rows.Count - 1; i++)
{
if (ValidateListItem(dgItemList.Rows[i]))
{
CGRDetails oGRDetails = new CGRDetails();
CCompanyBranch oCompanyBranch = (CCompanyBranch)cmbBranch.SelectedItem;
oGRDetails.GR_Date = DateTime.Now.Date;
oGRDetails.GRDet_Branch = oCompanyBranch.CompBrn_Code;
oGRDetails.GRDet_ItemOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colItemName"]).Value.ToString();
if (dgItemList.Rows[i].Cells["colIssueqty"].Value != null)
{
oGRDetails.GRDet_QTY = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colIssueqty"]).Value.ToString());
}
if (dgItemList.Rows[i].Cells["colIssueUOM"].Value != null)
{
oGRDetails.GRDet_UOM = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colIssueUOM"]).Value.ToString();
}
oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId;
if (dgItemList.Rows[i].Cells["colSourceLoc"].Value != null)
{
oGRDetails.GRDet_LocOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSourceLoc"]).Value.ToString();
}
if (dgItemList.Rows[i].Cells["colSrcInvType"].Value != null)
{
oGRDetails.GRDet_InvType = Convert.ToInt32(Enum.Parse(typeof(EInvType), ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSrcInvType"]).Value.ToString()));
}
if (dgItemList.Rows[i].Cells["colPrice"].Value != null)
{
oGRDetails.GRDet_Price = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colPrice"]).Value.ToString());
}
if (dgItemList.Rows[i].Cells["colCurrency"].Value != null)
{
oGRDetails.GRDet_Currency = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colCurrency"]).Value.ToString();
}
if (dgItemList.Rows[i].Cells["colAmount"].Value != null)
{
oGRDetails.GRDet_Amount = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colAmount"]).Value.ToString());
}
oGRMaster.GRMstr_DetailsList.Add(oGRDetails);
CGRDetails oInvGRDetails = new CGRDetails();
oInvGRDetails.GRDet_Branch = oGRDetails.GRDet_Branch;
oInvGRDetails.GRDet_BranchOID = oGRDetails.GRDet_BranchOID;
oInvGRDetails.GRDet_ItemOID = oGRDetails.GRDet_ItemOID;
oInvGRDetails.GRDet_LocOID = oGRDetails.GRDet_LocOID;
oInvGRDetails.GRDet_InvType = oGRDetails.GRDet_InvType;
if (dgItemList.Rows[i].Cells["colInvtQty"].Value != null)
{
oInvGRDetails.GRDet_QTY = float.Parse(((DataGridViewTextBoxCell)dgItemList.Rows[i].Cells["colInvtQty"]).Value.ToString());
}
else
{
oInvGRDetails.GRDet_QTY = 0.00f;
}
oGRFinalQtyDic.Add(oInvGRDetails.GRDet_ItemOID, oInvGRDetails);
}
else
{
return(null);
}
}
foreach (string obj in oGRExistingQtyDic.Keys)
{
if (!oGRFinalQtyDic.ContainsKey(obj))
{
CGRDetails objDetls = new CGRDetails();
objDetls.GRDet_Branch = oGRExistingQtyDic[obj].GRDet_Branch;
objDetls.GRDet_BranchOID = oGRExistingQtyDic[obj].GRDet_BranchOID;
objDetls.GRDet_InvType = oGRExistingQtyDic[obj].GRDet_InvType;
objDetls.GRDet_ItemOID = oGRExistingQtyDic[obj].GRDet_ItemOID;
objDetls.GRDet_LocOID = oGRExistingQtyDic[obj].GRDet_LocOID;
objDetls.GRDet_QTY = oGRExistingQtyDic[obj].GRDet_QTY * -1;
oGRFinalQtyDic.Add(obj, objDetls);
}
}
return(oGRMaster);
}
private void btnImport_Click(object sender, EventArgs e)
{
if (ValidationData())
{
CResult oResulto = new CResult();
CGRBO oGRBOo = new CGRBO();
CGRMaster oMastero = GetToBSavedDataExportBranch();
if (oMastero != null)
{
oResulto = oGRBOo.CreateExportInBranch(oMastero);
//if (oResulto.IsSuccess)
//{
// MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
// ClearFormData();
// GetGRNextCode();
//}
//else
//{
// MessageBox.Show(oResulto.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
}
#region import
//if (ValidationData())
//{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Title = "Save an CSV File";
saveFileDialog1.FileName = "InventoryExport.csv";
saveFileDialog1.ShowDialog();
string url = "";
if (saveFileDialog1.FileName != "")
{
url = saveFileDialog1.FileName;
}
else
{
url = "InventoryExport.csv";
}
// Data2PDF();
CResult oResult = new CResult();
CGRBO oGRBO = new CGRBO();
CGRMaster oMaster = GetToBSavedData();
if (oMaster != null)
{
if (!IsUpdateMode)
{
oResult = oGRBO.ExportAndUpdate(oMaster, url);
// SaveExcelFile(dt);
}
else
{
oResult = oGRBO.Update(oMaster, oGRFinalQtyDic);
}
if (oResult.IsSuccess)
{
MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFormData();
GetGRNextCode();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Inventory empty", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// }
#endregion
}
