public Window_Opening_stock()
{
InitializeComponent();
_ItemViewModel = new ItemViewModel();
this.DataContext = _ItemViewModel;
var GoDown = App.Current.Properties["GoDownList"] as List <AutoGodownModel>;
var BussLoc = App.Current.Properties["BussLocList"] as List <AutoBussinessModel>;
foreach (var item in BussLoc)
{
BussLocation.AddItem(new AutoBussinessModel
{
DisplayId = item.DisplayId,
DisplayName = item.DisplayName
});
}
foreach (var item in GoDown)
{
Godown.AddItem(new AutoGodownModel
{
DisplayId = item.DisplayId,
DisplayName = item.DisplayName
});
}
BussRef = BussLocation;
//Godown.Text = "";
GodownRef = Godown;
}
public Godown Post([FromBody] Godown objGodown)
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string sql = "INSERT INTO [dbo].[godown] ([code],[description],[address],[isdefault],[isactive]) VALUES(" + "'" + objGodown.Code + "','" + objGodown.Description + "','" + objGodown.Address + "','" + Convert.ToString(objGodown.IsDefault) + "','" + Convert.ToString(objGodown.IsActive) + "')";
command = new SqlCommand(sql, conn);
adapter.InsertCommand = new SqlCommand(sql, conn);
adapter.InsertCommand.ExecuteNonQuery();
sql = "select max(id) from [dbo].[godown]";
SqlCommand cmd = new SqlCommand(sql, conn);
int id = (int)cmd.ExecuteScalar();
command.Dispose();
conn.Close();
objGodown.Id = id;
return(objGodown);
}
public Godown Update([FromBody] Godown objGodown)
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string sql = "UPDATE [dbo].[godown]" +
" SET [code] = '" + objGodown.Code + "'" +
",[description] = '" + objGodown.Description + "'" +
",[address] = '" + objGodown.Address + "'" +
",[isdefault] = '" + objGodown.IsDefault + "'" +
",[isactive] = '" + objGodown.IsActive + "'" +
" WHERE id=" + objGodown.Id + "";
//string sql = "INSERT INTO [dbo].[racks] ([code],[description],[capacity],[isdefault],[isactive]) VALUES(" + "'" + objRack.Code + "','" + objRack.Description + "'," + objRack.Capacity + ",'" + Convert.ToString(objRack.IsDefault) + "','" + Convert.ToString(objRack.IsActive) + "')";
command = new SqlCommand(sql, conn);
adapter.UpdateCommand = new SqlCommand(sql, conn);
adapter.UpdateCommand.ExecuteNonQuery();
command.Dispose();
conn.Close();
return(objGodown);
}
public void ShowDlg(Godown oGodown, bool IsNew)
{
_IsNew = IsNew;
_Godown = oGodown;
RefreshValue();
this.ShowDialog();
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
int[] selRows = ((GridView)grdGodowns.MainView).GetSelectedRows();
DataRowView oCategoryD = (DataRowView)(((GridView)grdGodowns.MainView).GetRow(selRows[0]));
int nID = Convert.ToInt32(oCategoryD["ID"]);
Godown oGodown = db.Godowns.FirstOrDefault(p => p.GodownID == nID);
if (oGodown == null)
{
MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
db.Godowns.Attach(oGodown);
db.Godowns.Remove(oGodown);
db.SaveChanges();
MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshList();
}
;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
int[] selRows = ((GridView)grdGodowns.MainView).GetSelectedRows();
DataRowView oCategoryD = (DataRowView)(((GridView)grdGodowns.MainView).GetRow(selRows[0]));
int nID = Convert.ToInt32(oCategoryD["ID"]);
Godown oGodown = db.Godowns.FirstOrDefault(p => p.GodownID == nID);
if (oGodown == null)
{
MessageBox.Show("select an item to edit", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
fGodown frm = new fGodown();
frm.ItemChanged = RefreshList;
frm.ShowDlg(oGodown, false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Delete(int id)
{
Godown pt = Find(id);
pt.ObjectState = ObjectState.Deleted;
_unitOfWork.Repository <Godown>().Delete(pt);
}
public Godown Create(Godown pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <Godown>().Add(pt);
return(pt);
}
// GET: /GodownMaster/Create
public ActionResult Create()
{
Godown vm = new Godown();
vm.SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
vm.IsActive = true;
return(View("Create", vm));
}
public ActionResult DeleteConfirmed(ReasonViewModel vm)
{
if (ModelState.IsValid)
{
//Commit the DB
try
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
Godown temp = _GodownService.Find(vm.id);
int DocTypeId = (int)temp.DocTypeId;
LogList.Add(new LogTypeViewModel
{
ExObj = Mapper.Map <Godown>(temp),
});
IEnumerable <BinLocation> BinLocationList = _BinLocationService.GetBinLocationListForGodown(vm.id);
foreach (BinLocation item in BinLocationList)
{
_BinLocationService.Delete(item);
}
XElement Modifications = _modificationCheck.CheckChanges(LogList);
_GodownService.Delete(vm.id);
_logger.LogActivityDetail(logVm.Map(new ActiivtyLogViewModel
{
DocTypeId = DocTypeId,
DocId = temp.GodownId,
ActivityType = (int)ActivityTypeContants.Deleted,
UserRemark = vm.Reason,
DocNo = temp.GodownName,
xEModifications = Modifications,
DocDate = temp.CreatedDate,
}));
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
return(PartialView("_Reason", vm));
}
return(Json(new { success = true }));
}
return(PartialView("_Reason", vm));
}
// GET: /ProductMaster/Edit/5
public ActionResult Edit(int id)
{
Godown pt = _GodownService.Find(id);
if (pt == null)
{
return(HttpNotFound());
}
return(View("Create", pt));
}
// GET: /JobReceiveHeader/Create
public ActionResult Create()//DocumentTypeId
{
Godown vm = new Godown();
vm.DocTypeId = Constants.DocumentTypeIdConstants.Godown;
vm.SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
vm.IsActive = true;
ViewBag.Mode = "Add";
return(View("Create", vm));
}
// GET: /JobReceiveHeader/Edit/5
private ActionResult Edit(int id, string IndexType)
{
Godown pt = _GodownService.Find(id);
if (pt == null)
{
return(HttpNotFound());
}
ViewBag.Mode = "Edit";
return(View("Create", pt));
}
public static BaseGodownModel ToBaseGodown(this Godown godown)
{
BaseGodownModel _result = new BaseGodownModel();
_result.Id = godown.Id;
_result.GodownName = godown.GodownName;
_result.Narration = godown.Narration;
_result.CreatedDate = godown.CreatedDate;
_result.ModifiedDate = godown.ModifiedDate;
return(_result);
}
// POST: odata/Godowns
public async Task <IHttpActionResult> Post(Godown godown)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Godowns.Add(godown);
await db.SaveChangesAsync();
return(Created(godown));
}
public ActionResult _Create(int Id) //Id ==>GodownId
{
BinLocation s = new BinLocation();
ViewBag.LineMode = "Create";
Godown Godown = _GodownService.Find(Id);
ViewBag.DocNo = Godown.GodownName;
s.GodownId = Id;
return(PartialView("_Create", s));
}
//[ValidateAntiForgeryToken]
public ActionResult DeletePost(BinLocation vm)
{
bool BeforeSave = true;
if (BeforeSave)
{
try
{
Godown temp = _GodownService.Find(vm.GodownId);
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
BinLocation BinLocation = _BinLocationService.Find(vm.BinLocationId);
LogList.Add(new LogTypeViewModel
{
Obj = Mapper.Map <BinLocation>(BinLocation),
});
LogList.Add(new LogTypeViewModel
{
Obj = Mapper.Map <BinLocation>(BinLocation),
});
XElement Modifications = _modificationCheck.CheckChanges(LogList);
_BinLocationService.Delete(vm.BinLocationId);
_logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = (int)temp.DocTypeId,
DocId = temp.GodownId,
DocLineId = BinLocation.BinLocationId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = temp.GodownName,
xEModifications = Modifications,
DocDate = temp.CreatedDate,
}));
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
ViewBag.LineMode = "Delete";
return(PartialView("_Create", vm));
}
}
return(Json(new { success = true }));
}
// DELETE: odata/Godowns(5)
public async Task <IHttpActionResult> Delete([FromODataUri] short key)
{
Godown godown = await db.Godowns.FindAsync(key);
if (godown == null)
{
return(NotFound());
}
db.Godowns.Remove(godown);
await db.SaveChangesAsync();
return(StatusCode(HttpStatusCode.NoContent));
}
public static Godown ToGodown(this BaseGodownModel godown)
{
Godown _result = new Godown();
if (godown.Id.HasValue)
{
_result.Id = godown.Id.GetValueOrDefault();
}
_result.GodownName = godown.GodownName;
_result.Narration = godown.Narration;
_result.CreatedDate = godown.CreatedDate;
_result.ModifiedDate = godown.ModifiedDate;
return(_result);
}
// GET: /ProductMaster/Delete/5
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Godown Godown = db.Godown.Find(id);
if (Godown == null)
{
return(HttpNotFound());
}
ReasonViewModel vm = new ReasonViewModel()
{
id = id,
};
return(PartialView("_Reason", vm));
}
public static GodownViewModel Detach(Godown godown)
{
GodownViewModel godownviewmodel = new GodownViewModel();
godownviewmodel.GodownId = godown.GodownId;
godownviewmodel.GodownName = godown.GodownName;
godownviewmodel.GodownAddress = godown.GodownAddress;
godownviewmodel.ContactNo = godown.ContactNo;
godownviewmodel.ContactPerson = godown.ContactPerson;
godownviewmodel.CompanyId = godown.CompanyId;
godownviewmodel.BranchId = godown.BranchId;
godownviewmodel.Status = godown.Status;
godownviewmodel.CreatedBy = godown.CreatedBy;
godownviewmodel.CreatedOn = godown.CreatedOn;
godownviewmodel.UpdatedBy = godown.UpdatedBy;
godownviewmodel.UpdatedOn = godown.UpdatedOn;
return(godownviewmodel);
}
public IEnumerable <Godown> Get()
{
List <Godown> godowns = new List <Godown>();
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string sql = "SELECT * from godown";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Godown godown = new Godown();
godown.Id = reader.GetInt32(0);
godown.Code = reader.GetString(1);
godown.Description = reader.GetString(2);
godown.Address = reader.GetString(3);
godown.IsDefault = reader.GetBoolean(4);
godown.IsActive = reader.GetBoolean(5);
godowns.Add(godown);
}
}
conn.Close();
return(godowns);
}
catch (Exception ex)
{
throw ex;
}
}
private ActionResult Remove(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Godown Godown = _GodownService.Find(id);
if (Godown == null)
{
return(HttpNotFound());
}
ReasonViewModel rvm = new ReasonViewModel()
{
id = id,
};
return(PartialView("_Reason", rvm));
}
// PUT: odata/Godowns(5)
public async Task <IHttpActionResult> Put([FromODataUri] short key, Delta <Godown> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Godown godown = await db.Godowns.FindAsync(key);
if (godown == null)
{
return(NotFound());
}
patch.Put(godown);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GodownExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(godown));
}
public ActionResult _Modify(int id)
{
BinLocation temp = _BinLocationService.Find(id);
Godown Godown = _GodownService.Find(temp.GodownId);
ViewBag.DocNo = Godown.GodownName;
//Getting Settings
if (temp == null)
{
return(HttpNotFound());
}
if ((TimePlanValidation || Continue))
{
ViewBag.LineMode = "Edit";
}
return(PartialView("_Create", temp));
}
public ActionResult Post(Godown vm)
{
Godown pt = vm;
if (ModelState.IsValid)
{
if (vm.GodownId <= 0)
{
pt.IsActive = true;
pt.CreatedDate = DateTime.Now;
pt.ModifiedDate = DateTime.Now;
pt.CreatedBy = User.Identity.Name;
pt.ModifiedBy = User.Identity.Name;
pt.ObjectState = Model.ObjectState.Added;
_GodownService.Create(pt);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(View("Create", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.Godown).DocumentTypeId,
DocId = pt.GodownId,
ActivityType = (int)ActivityTypeContants.Added,
}));
return(RedirectToAction("Create").Success("Data saved successfully"));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
Godown temp = _GodownService.Find(pt.GodownId);
Godown ExRec = Mapper.Map <Godown>(temp);
temp.GodownName = pt.GodownName;
temp.GateId = pt.GateId;
temp.IsActive = pt.IsActive;
temp.ModifiedDate = DateTime.Now;
temp.ModifiedBy = User.Identity.Name;
temp.ObjectState = Model.ObjectState.Modified;
_GodownService.Update(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = temp,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(View("Create", pt));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.Godown).DocumentTypeId,
DocId = temp.GodownId,
ActivityType = (int)ActivityTypeContants.Modified,
xEModifications = Modifications,
}));
return(RedirectToAction("Index").Success("Data saved successfully"));
}
}
return(View("Create", vm));
}
public void Update(Godown godown)
{
godownRepository.Update(godown);
}
public void Add(Godown godown)
{
godownRepository.Add(godown);
}
public Godown GetGodownById(int id)
{
Godown Godown = godownRepository.GetById(id);
return(Godown);
}
//[ValidateAntiForgeryToken]
public ActionResult _CreatePost(BinLocation svm)
{
bool BeforeSave = true;
Godown temp = _GodownService.Find(svm.GodownId);
if (_BinLocationService.IsDuplicateBinLocationName(svm.GodownId, svm.BinLocationCode, svm.BinLocationId))
{
ModelState.AddModelError("BinLocationId", "Chak Code is already entered in Property.");
}
if (_BinLocationService.IsDuplicateBinLocationName(svm.GodownId, svm.BinLocationName, svm.BinLocationId))
{
ModelState.AddModelError("BinLocationId", "Chak Name is already entered in Property.");
}
if (svm.BinLocationId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
if (ModelState.IsValid && BeforeSave)
{
if (svm.BinLocationId <= 0)
{
try
{
svm.IsActive = true;
svm.CreatedDate = DateTime.Now;
svm.ModifiedDate = DateTime.Now;
svm.CreatedBy = User.Identity.Name;
svm.ModifiedBy = User.Identity.Name;
svm.ObjectState = Model.ObjectState.Added;
_BinLocationService.Create(svm);
_logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = (int)temp.DocTypeId,
DocId = temp.GodownId,
DocLineId = svm.BinLocationId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp.GodownName,
DocDate = temp.CreatedDate,
}));
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
return(RedirectToAction("_Create", new { id = svm.GodownId }));
}
else
{
try
{
BinLocation binlocation = _BinLocationService.Find(svm.BinLocationId);
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
BinLocation ExTempLine = new BinLocation();
ExTempLine = Mapper.Map <BinLocation>(binlocation);
binlocation.BinLocationCode = svm.BinLocationCode;
binlocation.BinLocationName = svm.BinLocationName;
binlocation.IsActive = svm.IsActive;
binlocation.ModifiedDate = DateTime.Now;
binlocation.ModifiedBy = User.Identity.Name;
binlocation.ObjectState = Model.ObjectState.Modified;
_BinLocationService.Update(binlocation);
LogList.Add(new LogTypeViewModel
{
ExObj = ExTempLine,
Obj = binlocation
});
XElement Modifications = _modificationCheck.CheckChanges(LogList);
_logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = (int)temp.DocTypeId,
DocId = temp.GodownId,
DocLineId = binlocation.BinLocationId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.GodownName,
xEModifications = Modifications,
DocDate = temp.CreatedDate,
}));
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
return(Json(new { success = true }));
}
}
return(PartialView("_Create", svm));
}
