public int Cancel(ViewReplaceModel replaceModel, int userId)
{
try
{
CommandObj.CommandText = "UDSP_CancelReplaceEntry";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@UserId", userId);
CommandObj.Parameters.AddWithValue("@Remarks", replaceModel.CancelRemarks);
CommandObj.Parameters.AddWithValue("@ReceiveId", replaceModel.ReceiveId);
CommandObj.Parameters.Add("@RowAffected", SqlDbType.Int);
CommandObj.Parameters["@RowAffected"].Direction = ParameterDirection.Output;
ConnectionObj.Open();
CommandObj.ExecuteNonQuery();
var rowAffected = Convert.ToInt32(CommandObj.Parameters["@RowAffected"].Value);
return(rowAffected);
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
throw new Exception("Could not cancel the replace entry by id", exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
CommandObj.Parameters.Clear();
}
}
public ActionResult Delivery(long id)
{
try
{
ViewReplaceModel model = new ViewReplaceModel();
int branchId = Convert.ToInt32(Session["BranchId"]);
int companyId = Convert.ToInt32(Session["CompanyId"]);
var stock = _iInventoryManager.GetStockProductInBranchByBranchAndCompanyId(branchId, companyId);
var received = _iServiceManager.GetDeliverableServiceProductById(id);
Session["Branch_stock"] = stock;
var client = _iClientManager.GetById(received.ClientId);
var products = new List <ViewReplaceDetailsModel>
{
new ViewReplaceDetailsModel
{
ExpiryDate = received.ExpiryDate,
ProductId = received.ProductId,
ProductName = received.ProductName,
Quantity = 1
}
};
model.ClientCode = client.SubSubSubAccountCode;
model.ClientName = client.ClientName;
model.ClientAddress = client.Address;
model.Products = products;
model.ReceiveId = id;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public int ChangeReplaceProuctType(ViewReplaceModel model)
{
try
{
CommandObj.CommandText = "UDSP_ChangeReplaceProuctType";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.AddWithValue("@ReceiveId", model.ReceiveId);
CommandObj.Parameters.AddWithValue("@ProductId", model.ProductId);
CommandObj.Parameters.AddWithValue("@NewProductId", model.NewProductId);
CommandObj.Parameters.AddWithValue("@Remarks", model.Remarks);
CommandObj.Parameters.Add("@RowAffected", SqlDbType.Int);
CommandObj.Parameters["@RowAffected"].Direction = ParameterDirection.Output;
ConnectionObj.Open();
CommandObj.ExecuteNonQuery();
var rowAffected = Convert.ToInt32(CommandObj.Parameters["@RowAffected"].Value);
return(rowAffected);
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
throw new Exception("Could not update replace product..", exception);
}
finally
{
CommandObj.Dispose();
ConnectionObj.Close();
CommandObj.Parameters.Clear();
}
}
public ActionResult UpdateCliaimedBatteryDeliveryStatus(long id, FormCollection collection)
{
try
{
var product = _iServiceManager.GetReceivedServiceProductById(id);
var deliveryDate = Convert.ToDateTime(collection["DeliveryDate"]);
bool result = _iServiceManager.UpdateCliaimedBatteryDeliveryStatus(id, deliveryDate);
if (result)
{
if (product.ForwardedToId == 5)
{
return(RedirectToAction("ReturnList"));
}
return(RedirectToAction("CharegReturnList"));
}
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(id).ToList();
model.Products = products;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult PrintChallan(long id)
{
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(id).ToList();
model.Products = products;
return(View(model));
}
public ActionResult ChangeProuctType(long id)
{
try
{
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ViewReplaceModel GetReplaceById(long id)
{
try
{
ViewReplaceModel model = null;
CommandObj.CommandText = "UDSP_GetReplaceById";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.AddWithValue("@ReceiveId", id);
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
if (reader.Read())
{
model = new ViewReplaceModel
{
ReceiveId = id,
ClientCode = reader["ClientCode"].ToString(),
ClientId = Convert.ToInt32(reader["ClientId"]),
ClientName = reader["ClientName"].ToString(),
ClientAddress = reader["ClientAddress"].ToString(),
EntryDate = Convert.ToDateTime(reader["SysDateTime"]),
ReceiveRef = reader["ReceiveRef"].ToString(),
BranchId = Convert.ToInt32(reader["ReceiveByBranchId"]),
CompanyId = Convert.ToInt32(reader["CompanyId"]),
UserId = Convert.ToInt32(reader["EntryByUserId"]),
ReplaceForBarcode = reader["BarcodeNo"].ToString(),
ProductName = reader["ProductName"].ToString(),
ProductId = Convert.ToInt32(reader["ProductId"]),
Remarks = reader["ReceiveReport"].ToString(),
SaleDate = DBNull.Value.Equals(reader["SaleDate"]) ? (DateTime?)null:Convert.ToDateTime(reader["SaleDate"]),
ExpiryDate = DBNull.Value.Equals(reader["ExpiryDate"]) ? (DateTime?)null : Convert.ToDateTime(reader["ExpiryDate"]),
RbdDate = DBNull.Value.Equals(reader["RbdDate"]) ? (DateTime?)null:Convert.ToDateTime(reader["RbdDate"]),
RbdBarcode = DBNull.Value.Equals(reader["RbdBarcode"]) ? null:reader["RbdBarcode"].ToString(),
RbdRemarks = DBNull.Value.Equals(reader["RbdRemarks"]) ?null:reader["RbdRemarks"].ToString(),
DistributionPoint = DBNull.Value.Equals(reader["DistributionPoint"]) ? null : reader["DistributionPoint"].ToString(),
};
}
reader.Close();
return(model);
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
throw new Exception("Could not collect Replace by Id", exception);
}
finally
{
CommandObj.Dispose();
ConnectionObj.Close();
CommandObj.Parameters.Clear();
}
}
public ActionResult UpdateCliaimedBatteryDeliveryStatus(long id)
{
try
{
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(id).ToList();
model.Products = products;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult Delivery(long id)
{
try
{
var stock = _iInventoryManager.GetStockProductInFactory();
Session["Factory_stock12"] = stock;
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(id).ToList();
model.Products = products;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult ChangeProuctType(long id, ViewReplaceModel model)
{
try
{
model.ReceiveId = id;
bool result = _iProductReplaceManager.ChangeReplaceProuctType(model);
if (result)
{
return(RedirectToAction("ReplaceList", "WarrantyBattery"));
}
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult Edit(long id, ViewReplaceModel model)
{
try
{
model.ReceiveId = id;
bool result = _iProductReplaceManager.EditReplaceEntry(model);
if (result)
{
return(RedirectToAction("ViewAll"));
}
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult WarrantyDelivery(long id)
{
try
{
int branchId = Convert.ToInt32(Session["BranchId"]);
int companyId = Convert.ToInt32(Session["CompanyId"]);
var stock = _iInventoryManager.GetStockProductInBranchByBranchAndCompanyId(branchId, companyId);
Session["Branch_stock"] = stock;
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(id);
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(id).ToList();
model.Products = products;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public ActionResult Cancel(ViewReplaceModel replaceModel)
{
try
{
ViewReplaceModel model = _iProductReplaceManager.GetReplaceById(replaceModel.ReceiveId);
var user = (ViewUser)Session["user"];
int rowAffected = _iProductReplaceManager.Cancel(replaceModel, user.UserId);
if (rowAffected > 0)
{
return(RedirectToAction("ViewAll"));
}
List <ViewReplaceDetailsModel> products = _iProductReplaceManager.GetReplaceProductListById(replaceModel.ReplaceId).ToList();
model.Products = products;
return(View(model));
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
//-----------------------Replace---------------------
public string SaveReplaceDeliveryInfo(List <ScannedProduct> scannedProducts, Delivery aDelivery, int replaceStatus, ViewReplaceModel replaceModel)
{
string refCode = _iCommonGateway.GetAllSubReferenceAccounts().ToList().Find(n => n.Id == Convert.ToInt32(ReferenceType.Distribution)).Code;
aDelivery.VoucherNo = GetMaxVoucherNoByTransactionInfix(refCode);
int maxRefNo = _iInventoryGateway.GetMaxDeliveryRefNoOfCurrentYear();
aDelivery.DeliveryRef = GenerateDeliveryReference(maxRefNo);
int rowAffected = _iInventoryGateway.SaveReplaceDeliveryInfo(scannedProducts, aDelivery, replaceStatus, replaceModel);
return(rowAffected > 0 ? "Saved Successfully!" : "Failed to Save");
}
public int Cancel(ViewReplaceModel replaceModel, int userId)
{
return(_iProductReplaceGateway.Cancel(replaceModel, userId));
}
public bool ChangeReplaceProuctType(ViewReplaceModel model)
{
int rowAffected = _iProductReplaceGateway.ChangeReplaceProuctType(model);
return(rowAffected > 0);
}
public bool EditReplaceEntry(ViewReplaceModel model)
{
int rowAffected = _iProductReplaceGateway.EditReplaceEntry(model);
return(rowAffected > 0);
}
