public override string ToString()
{
var returnString =
$"Key: {Key.ToKeyString()}," +
$" Text: {Text}," +
$" Flag: {Flag}," +
$" Number: {Number}," +
$" Amount: {Amount}," +
$" Amount4: {Amount4}," +
$" Amount5: {Amount5}," +
$" PreciseDecimal: {PreciseDecimal}," +
$" SampleState: {SampleState}," +
$" DateOnly: {DateOnly.ToShortDateString()}," +
$" TimeOnly: {TimeOnly}," +
$" DateTimeTicks: {DateTimeTicks}," +
$" DateTimeMinute: {DateTimeMinute}," +
$" DateTimeSecond: {DateTimeSecond}," +
$" OneMaster: {OneMaster?.ToShortString()}," +
$" OtherMaster: {OtherMaster?.ToShortString()}," +
$" Optional: {Optional}," +
$" SampleDetails: {SampleDetails.Count};";
onToString(ref returnString);
return(returnString);
}
private void Validate_Sucess(ref OtherMasterViewModel objMasterView, int Id)
{
if (Id > 0)
{
objMasterView.Message = "Saved Sucess";
objMasterView.IsReset = 1;
}
else if (Id == -1)
{
OtherMaster objOtherMaster = new OtherMaster();
objMasterView.lstOtherMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
ViewData["Result"] = "Record Already Exist ' " + objMasterView.Name + " '";
objMasterView.Message = "Record Already Exist ' " + objMasterView.Name + " '";
ModelState.AddModelError("Name", "Record Already Exist");
objMasterView.IsReset = 0;
objMasterView.IsRepeat = 1;
objMasterView.GroupMasters = new SelectList(_IOtherMasterService.GetGroupMaster(), "GroupMasterID", "Category", "-select-");
// return View("Index",objMasterView);
// RedirectToAction("Load");
// Load(objMasterView);
}
else
{
objMasterView.IsReset = 0;
objMasterView.Message = "Error Occured";
// Load(objMasterView);
}
}
public ActionResult Create(OtherMasterViewModel objMasterView)
{
// if (ModelState.IsValid)
{
OtherMaster objMaster = new OtherMaster();
objMaster.GroupMasterID = objMasterView.GroupMasterId;
objMaster.Name = objMasterView.Name;
objMaster.IsCommonCostCode = objMasterView.IsCommonCostCode;
objMaster.CreatedByID = Convert.ToInt32(Session["EmpID"]);
int Id = 0;
if (objMasterView.MasterId == 0)
{
Id = _IOtherMasterService.Insert_OtherMaster(objMaster);
}
else
{
objMasterView.IsEdit = 1;
objMaster.LastModifiedByID = Convert.ToInt32(Session["EmpID"]);
objMaster.MasterID = objMasterView.MasterId;
Id = _IOtherMasterService.Update_OtherMaster(objMaster);
}
Validate_Sucess(ref objMasterView, Id);
return(Load(objMasterView));
}
// else
// return View("Error");
}
public PartialViewResult LoadAllMasters(int GroupMasterId)
{
OtherMaster objOtherMaster = new OtherMaster();
OtherMasterViewModel objMasterviewModel = new OtherMasterViewModel();
objOtherMaster.GroupMasterID = GroupMasterId;
objMasterviewModel.lstOtherMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
return(PartialView(RMS.Common.Constants.CommonConstants.PartialListMasters, objMasterviewModel));
}
public ActionResult Index()
{
OtherMasterViewModel objMasterviewModel = new OtherMasterViewModel();
OtherMaster objOtherMaster = new OtherMaster();
objMasterviewModel.lstOtherMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
objMasterviewModel.GroupMasters = new SelectList(_IOtherMasterService.GetGroupMaster(), "GroupMasterID", "Category", "-select-");
return(View(objMasterviewModel));
}
public int DeleteOtherMaster(OtherMaster objOtherMaster)
{
DataAccessClass objData = new DataAccessClass();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@LastModifiedByID", objOtherMaster.LastModifiedByID);
cmd.Parameters.AddWithValue("@MasterID", objOtherMaster.MasterID);
return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Delete_OtherMaster, cmd)));
}
public ActionResult Load(OtherMasterViewModel objMasterviewModel)
{
OtherMaster objOtherMaster = new OtherMaster();
// OtherMasterViewModel objMasterviewModel = new OtherMasterViewModel();
objOtherMaster.GroupMasterID = 0;
objMasterviewModel.lstOtherMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
objMasterviewModel.GroupMasterId = 0;
objMasterviewModel.Name = "";
// objMasterviewModel.IsReset = 1;
return(PartialView(RMS.Common.Constants.CommonConstants.PartialListMasters, objMasterviewModel));
}
public int SaveOtherMaster(OtherMaster objOtherMaster)
{
DataAccessClass objData = new DataAccessClass();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@GroupMasterID", objOtherMaster.GroupMasterID);
cmd.Parameters.AddWithValue("@CreatedByID", objOtherMaster.CreatedByID);
cmd.Parameters.AddWithValue("@Name", objOtherMaster.Name);
cmd.Parameters.AddWithValue("@IsCommonCostCode", objOtherMaster.IsCommonCostCode);
// cmd.Parameters.AddWithValue("@Category", objOtherMaster.Category);
return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Insert_OtherMaster, cmd)));
}
//[HttpPost]
//public ActionResult Edit(OtherMasterViewModel objMasterView)
//{
// if (ModelState.IsValid)
// {
// OtherMaster objMaster = new OtherMaster();
// objMaster.GroupMasterID = objMasterView.GroupMasterId;
// objMaster.Name = objMasterView.Name;
// objMaster.LastModifiedByID = Convert.ToInt32(Session["EmpID"]);
// objMaster.MasterID = objMasterView.MasterId;
// int Id = _IOtherMasterService.Update_OtherMaster(objMaster);
// return Validate_Sucess(ref objMasterView, Id);
// }
// else
// return View("Error");
//}
public ActionResult Delete(int id)
{
OtherMaster objMaster = new OtherMaster();
objMaster.LastModifiedByID = Convert.ToInt32(Session["EmpID"]);
objMaster.MasterID = id;
int Id = _IOtherMasterService.Delete_OtherMaster(objMaster);
if (Id > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View("Error"));
}
}
public JsonResult SaveOtherMaster(OtherMaster otherMaster)
{
try
{
if (ModelState.IsValid)
{
otherMaster.CreatedDate = DateTime.Now;
otherMaster.UpdatedDate = DateTime.Now;
otherMaster.IsDeleted = false;
_repository.Insert(otherMaster);
_repository.Save();
return(Json(Functions.OutPutResponse(true, "Data Inserted Succfully", otherMaster)));
}
return(Json(Functions.OutPutResponse(false, "Invalid Data")));
}
catch (Exception ex) {
return(Json(Functions.OutPutResponse(false, ex.Message)));
}
}
public List <OtherMasterResult> GetOtherMaster(OtherMaster objOtherMaster)
{
DataAccessClass objData = new DataAccessClass();
SqlCommand cmd = new SqlCommand();
if (objOtherMaster.MasterID != 0)
{
cmd.Parameters.AddWithValue("@MasterID", objOtherMaster.MasterID);
}
if (objOtherMaster.GroupMasterID != 0)
{
cmd.Parameters.AddWithValue("@GroupMasterID", objOtherMaster.GroupMasterID);
}
return(objData.ExecuteReaderSP_WithConnection <OtherMasterResult>(SPNames.Get_OtherMaster, cmd));
}
public ActionResult Edit(int id)
{
OtherMaster objOtherMaster = new OtherMaster();
objOtherMaster.MasterID = id;
List <OtherMasterResult> lstMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
OtherMasterViewModel objMasterviewModel = new OtherMasterViewModel();
objMasterviewModel.GroupMasters = new SelectList(_IOtherMasterService.GetGroupMaster(), "GroupMasterID", "Category", "-select-");
if (lstMasters.Count > 0)
{
objMasterviewModel.GroupMasterId = lstMasters.FirstOrDefault().GroupMasterID;
objMasterviewModel.Name = lstMasters.FirstOrDefault().Name;
objMasterviewModel.MasterId = lstMasters.FirstOrDefault().MasterID;
objMasterviewModel.IsCommonCostCode = (lstMasters.FirstOrDefault().IsCommon_CostCode.ToUpper() == "YES") ? true : false;
}
objOtherMaster = new OtherMaster();
objMasterviewModel.lstOtherMasters = _IOtherMasterService.Get_OtherMaster(objOtherMaster);
return(View("Index", objMasterviewModel));
}
public string ToShortString()
{
var returnString =
$"{Key.ToKeyString()}," +
$" {Text}," +
$" {Flag}," +
$" {Number}," +
$" {Amount}," +
$" {Amount4}," +
$" {Amount5}," +
$" {PreciseDecimal}," +
$" {SampleState}," +
$" {DateOnly.ToShortDateString()}," +
$" {TimeOnly}," +
$" {DateTimeTicks}," +
$" {DateTimeMinute}," +
$" {DateTimeSecond}," +
$" {OneMaster?.ToShortString()}," +
$" {OtherMaster?.ToShortString()}," +
$" {Optional}";
onToShortString(ref returnString);
return(returnString);
}
public string ToTraceString()
{
var returnString =
$"{this.GetKeyOrHash()}|" +
$" {Text}|" +
$" {Flag}|" +
$" {Number}|" +
$" {Amount}|" +
$" {Amount4}|" +
$" {Amount5}|" +
$" {PreciseDecimal}|" +
$" {SampleState}|" +
$" {DateOnly.ToShortDateString()}|" +
$" {TimeOnly}|" +
$" {DateTimeTicks}|" +
$" {DateTimeMinute}|" +
$" {DateTimeSecond}|" +
$" OneMaster {OneMaster?.GetKeyOrHash()}|" +
$" OtherMaster {OtherMaster?.GetKeyOrHash()}|" +
$" {Optional}";
onToTraceString(ref returnString);
return(returnString);
}
public int Insert_OtherMaster(OtherMaster objMaster)
{
return(_IOtherMasterRepository.SaveOtherMaster(objMaster));
}
public void Update(
string text,
bool flag,
int number,
decimal amount,
decimal amount4,
decimal?amount5,
decimal preciseDecimal,
SampleStateEnum sampleState,
DateTime dateOnly,
TimeSpan timeOnly,
DateTime dateTimeTicks,
DateTime dateTimeMinute,
DateTime dateTimeSecond,
SampleMaster?oneMaster,
SampleMaster?otherMaster,
string?optional)
{
if (Key >= 0)
{
if (oneMaster?.Key < 0)
{
throw new Exception($"Sample.Update(): It is illegal to add stored Sample '{this}'" + Environment.NewLine +
$"to OneMaster '{oneMaster}', which is not stored.");
}
if (otherMaster?.Key < 0)
{
throw new Exception($"Sample.Update(): It is illegal to add stored Sample '{this}'" + Environment.NewLine +
$"to OtherMaster '{otherMaster}', which is not stored.");
}
}
var clone = new Sample(this);
var isCancelled = false;
onUpdating(
text,
flag,
number,
amount,
amount4,
amount5,
preciseDecimal,
sampleState,
dateOnly,
timeOnly,
dateTimeTicks,
dateTimeMinute,
dateTimeSecond,
oneMaster,
otherMaster,
optional,
ref isCancelled);
if (isCancelled)
{
return;
}
#if DEBUG
DC.Trace?.Invoke($"Updating Sample: {ToTraceString()}");
#endif
var isChangeDetected = false;
if (Text != text)
{
Text = text;
isChangeDetected = true;
}
if (Flag != flag)
{
Flag = flag;
isChangeDetected = true;
}
if (Number != number)
{
Number = number;
isChangeDetected = true;
}
var amountRounded = amount.Round(2);
if (Amount != amountRounded)
{
Amount = amountRounded;
isChangeDetected = true;
}
var amount4Rounded = amount4.Round(4);
if (Amount4 != amount4Rounded)
{
Amount4 = amount4Rounded;
isChangeDetected = true;
}
var amount5Rounded = amount5.Round(5);
if (Amount5 != amount5Rounded)
{
Amount5 = amount5Rounded;
isChangeDetected = true;
}
if (PreciseDecimal != preciseDecimal)
{
PreciseDecimal = preciseDecimal;
isChangeDetected = true;
}
if (SampleState != sampleState)
{
SampleState = sampleState;
isChangeDetected = true;
}
var dateOnlyRounded = dateOnly.Floor(Rounding.Days);
if (DateOnly != dateOnlyRounded)
{
DateOnly = dateOnlyRounded;
isChangeDetected = true;
}
var timeOnlyRounded = timeOnly.Round(Rounding.Seconds);
if (TimeOnly != timeOnlyRounded)
{
TimeOnly = timeOnlyRounded;
isChangeDetected = true;
}
if (DateTimeTicks != dateTimeTicks)
{
DateTimeTicks = dateTimeTicks;
isChangeDetected = true;
}
var dateTimeMinuteRounded = dateTimeMinute.Round(Rounding.Minutes);
if (DateTimeMinute != dateTimeMinuteRounded)
{
DateTimeMinute = dateTimeMinuteRounded;
isChangeDetected = true;
}
var dateTimeSecondRounded = dateTimeSecond.Round(Rounding.Seconds);
if (DateTimeSecond != dateTimeSecondRounded)
{
DateTimeSecond = dateTimeSecondRounded;
isChangeDetected = true;
}
if (OneMaster is null)
{
if (oneMaster is null)
{
//nothing to do
}
else
{
OneMaster = oneMaster;
OneMaster.AddToSampleX(this);
isChangeDetected = true;
}
}
else
{
if (oneMaster is null)
{
OneMaster.RemoveFromSampleX(this);
OneMaster = null;
isChangeDetected = true;
}
else
{
if (OneMaster != oneMaster)
{
OneMaster.RemoveFromSampleX(this);
OneMaster = oneMaster;
OneMaster.AddToSampleX(this);
isChangeDetected = true;
}
}
}
if (OtherMaster is null)
{
if (otherMaster is null)
{
//nothing to do
}
else
{
OtherMaster = otherMaster;
OtherMaster.AddToSampleX(this);
isChangeDetected = true;
}
}
else
{
if (otherMaster is null)
{
OtherMaster.RemoveFromSampleX(this);
OtherMaster = null;
isChangeDetected = true;
}
else
{
if (OtherMaster != otherMaster)
{
OtherMaster.RemoveFromSampleX(this);
OtherMaster = otherMaster;
OtherMaster.AddToSampleX(this);
isChangeDetected = true;
}
}
}
if (Optional != optional)
{
Optional = optional;
isChangeDetected = true;
}
if (isChangeDetected)
{
onUpdated(clone);
if (Key >= 0)
{
DC.Data.SampleX.ItemHasChanged(clone, this);
}
else if (DC.Data.IsTransaction)
{
DC.Data.AddTransaction(new TransactionItem(7, TransactionActivityEnum.Update, Key, this, oldItem: clone));
}
HasChanged?.Invoke(clone, this);
}
#if DEBUG
DC.Trace?.Invoke($"Updated Sample: {ToTraceString()}");
#endif
}
public int Delete_OtherMaster(OtherMaster objMaster)
{
return(_IOtherMasterRepository.DeleteOtherMaster(objMaster));
}
public List <OtherMasterResult> Get_OtherMaster(OtherMaster objMaster)
{
return(_IOtherMasterRepository.GetOtherMaster(objMaster));
}
public int Update_OtherMaster(OtherMaster objMaster)
{
return(_IOtherMasterRepository.UpdateOtherMaster(objMaster));
}
