public int UpdateCostingOption(UpdateOptionModel optionModel)
{
int actionResult = 0;
try
{
OpenConnection();
ArrayList arlSqlParameter = new ArrayList();
arlSqlParameter.Add(new SqlParameter("@Id", optionModel.OptionId));
arlSqlParameter.Add(new SqlParameter("@Number", optionModel.OptionNumber));
arlSqlParameter.Add(new SqlParameter("@Addition", optionModel.OptionAddition));
arlSqlParameter.Add(new SqlParameter("@Reduction", optionModel.OptionReduction));
arlSqlParameter.Add(new SqlParameter("@description", optionModel.OptionDescription));
arlSqlParameter.Add(new SqlParameter("@Remarks", optionModel.OptionRemarks));
actionResult = this.ExecuteActionQuery("[kp].[USP_UpdateCostionOption]", arlSqlParameter);
return(actionResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
}
}
public void Update(UpdateOptionModel model)
{
List <Option> options = _options.ToList();
options.Where(op => op.Name.Equals("SiteUrl")).FirstOrDefault().Value = model.SiteUrl;
options.Where(op => op.Name.Equals("BlogName")).FirstOrDefault().Value = model.BlogName;
options.Where(op => op.Name.Equals("BlogKeywords")).FirstOrDefault().Value = model.BlogKeywords;
options.Where(op => op.Name.Equals("BlogDescription")).FirstOrDefault().Value = model.BlogDescription;
options.Where(op => op.Name.Equals("UsersCanRegister")).FirstOrDefault().Value = model.UsersCanRegister.ToString();
options.Where(op => op.Name.Equals("AdminEmail")).FirstOrDefault().Value = model.AdminEmail;
options.Where(op => op.Name.Equals("CommentsNotify")).FirstOrDefault().Value = Convert.ToString(model.CommentsNotify);
options.Where(op => op.Name.Equals("MailServerUrl")).FirstOrDefault().Value = model.MailServerUrl;
options.Where(op => op.Name.Equals("MailServerLogin")).FirstOrDefault().Value = model.MailServerLogin;
options.Where(op => op.Name.Equals("MailServerPass")).FirstOrDefault().Value = model.MailServerPass;
options.Where(op => op.Name.Equals("MailServerPort")).FirstOrDefault().Value = model.MailServerPort.ToString();
options.Where(op => op.Name.Equals("CommentModeratingStatus")).FirstOrDefault().Value = model.CommentModeratingStatus.ToString();
options.Where(op => op.Name.Equals("PostPerPage")).FirstOrDefault().Value = model.PostPerPage.ToString();
options.Where(op => op.Name.Equals("CustomSourcePercent")).FirstOrDefault().Value = model.CustomSourcePercent.ToString();
options.Where(op => op.Name.Equals("VATPercent")).FirstOrDefault().Value = model.VATPercent.ToString();
options.Where(op => op.Name.Equals("AboutDescription")).FirstOrDefault().Value = model.AboutDescription;
options.Where(op => op.Name.Equals("CompanyAddress")).FirstOrDefault().Value = model.CompanyAddress;
options.Where(op => op.Name.Equals("Phone")).FirstOrDefault().Value = model.Phone;
options.Where(op => op.Name.Equals("Fax")).FirstOrDefault().Value = model.Fax;
options.Where(op => op.Name.Equals("eMail")).FirstOrDefault().Value = model.eMail;
options.Where(op => op.Name.Equals("Facebook")).FirstOrDefault().Value = model.Facebook;
options.Where(op => op.Name.Equals("Linkedin")).FirstOrDefault().Value = model.Linkedin;
options.Where(op => op.Name.Equals("GooglePlus")).FirstOrDefault().Value = model.GooglePlus;
options.Where(op => op.Name.Equals("Telegram")).FirstOrDefault().Value = model.Telegram;
}
public async Task <OptionEntity> Update(int id, UpdateOptionModel model)
{
var option = Get(id);
if (option == null)
{
throw new NotFoundException($"Option with id {id} not found");
}
option.Code = model.Code;
option.Name = model.Name;
option.Value = model.Value;
option.ManufacturerEntityId = model.ManufacturerEntityId;
option.Price = model.Price;
option.QtyStock = model.QtyStock;
option.ModifyUserId = model.ModifyUserId;
option.StatusId = model.StatusId;
await _unitOfWork.CommitAsync();
return(option);
}
protected void updateButton_Click(object sender, EventArgs e)
{
UpdateOptionModel costingOption = new UpdateOptionModel();
SmvBLL smv = new SmvBLL();
int action = 0;
try
{
if (optionId > 0)
{
costingOption.OptionId = optionId;
costingOption.OptionNumber = optionNumberTextBox.Text;
costingOption.OptionReduction = reductionTextBox.Text;
costingOption.OptionAddition = additionTextBox.Text;
costingOption.OptionDescription = descriptionTextBox.Text;
costingOption.OptionRemarks = remarksTextBox.Text;
action = smv.UpdateCostingOption(costingOption);
if (action > 0)
{
massageSpan.InnerText = "Costing Option has Been Updated";
table = LoadCostingInfo(smvId);
Clear();
//Response.Redirect("CostingOption.aspx");
}
else
{
massageSpan.InnerText = "Faield";
}
}
else
{
massageSpan.InnerText = "This Data Not Found In Our Store";
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(UpdateOptionModel model)
{
bool b = false;
//List<Option> options = _options.ToList();
//options.Where(op => op.Name.Equals("FileUrl")).FirstOrDefault().Value = model.FileUrl;
string ff = model.FileUrl;
if (!string.IsNullOrEmpty(ff))
{
ff = (ff.EndsWith(@"\") ? ff.Substring(0, ff.LastIndexOf(@"\")):ff);
}
var entity = _options.Where(x => x.Name.Equals("FileUrl")).FirstOrDefault();
if (entity != null)
{
entity.Value = ff;// model.FileUrl;
_options.Attach(entity);
_uow.Entry(entity).State = EntityState.Modified;
b = _uow.SaveChanges() > 0;
}
return(b);
}
public void Update(UpdateOptionModel model)
{
List <Option> options = _options.ToList();
options.Where(op => op.Name.Equals("SiteUrl")).FirstOrDefault().Value = model.SiteUrl;
options.Where(op => op.Name.Equals("BlogName")).FirstOrDefault().Value = model.BlogName;
options.Where(op => op.Name.Equals("BlogKeywords")).FirstOrDefault().Value = model.BlogKeywords;
options.Where(op => op.Name.Equals("BlogDescription")).FirstOrDefault().Value = model.BlogDescription;
options.Where(op => op.Name.Equals("UsersCanRegister")).FirstOrDefault().Value =
model.UsersCanRegister.ToString();
options.Where(op => op.Name.Equals("AdminEmail")).FirstOrDefault().Value = model.AdminEmail;
options.Where(op => op.Name.Equals("CommentsNotify")).FirstOrDefault().Value =
Convert.ToString(model.CommentsNotify);
options.Where(op => op.Name.Equals("MailServerUrl")).FirstOrDefault().Value = model.MailServerUrl;
options.Where(op => op.Name.Equals("MailServerLogin")).FirstOrDefault().Value = model.MailServerLogin;
options.Where(op => op.Name.Equals("MailServerPass")).FirstOrDefault().Value = model.MailServerPass;
options.Where(op => op.Name.Equals("MailServerPort")).FirstOrDefault().Value =
model.MailServerPort.ToString();
options.Where(op => op.Name.Equals("CommentModeratingStatus")).FirstOrDefault().Value =
model.CommentModeratingStatus
.ToString();
options.Where(op => op.Name.Equals("PostPerPage")).FirstOrDefault().Value = model.PostPerPage.ToString();
}