public virtual async Task <DTO.Comment> GetCommentByIdAndShop(int id, int?shopId)
{
var res = await RepositoryDbSet
.Include(a => a.CommentTitle).ThenInclude(t => t.Translations)
.Include(a => a.CommentBody).ThenInclude(t => t.Translations)
.Include(a => a.Product).ThenInclude(aa => aa.ProductName).ThenInclude(t => t.Translations)
.Where(s => s.Id == id && s.ShopId == shopId)
.Select(c => new
{
Id = c.Id,
CommentTitle = c.CommentTitle,
CommentBody = c.CommentBody,
ProductName = c.Product.ProductName,
ProductId = c.ProductId,
ShopId = c.ShopId,
CommentBodyTranslations = c.CommentBody.Translations,
CommentTitleTranslations = c.CommentTitle.Translations,
ProductNameTranslations = c.Product.ProductName.Translations
}).FirstOrDefaultAsync();
var result = new DTO.Comment()
{
Id = res.Id,
CommentTitle = res.CommentTitle.Translate(),
CommentBody = res.CommentBody.Translate(),
ProductName = res.ProductName.Translate(),
ProductId = res.ProductId,
ShopId = res.ShopId
};
return(result);
}
public DTO.Comment SetValue()
{
Ob = new DTO.Comment();
Ob.CommentName = txtComment.Text.ToUpper();
Ob.Active = 1;
Ob.DateModified = Globals.date[0].ToString();
Ob.CommentID = lblUpdateId.Text;
Ob.BranchId = Globals.BranchID;
return(Ob);
}
public void setDefault()
{
btnSave.Visible = true;
btnEdit.Visible = false;
txtComment.Focus();
txtComment.Text = "";
Ob = SetValue();
grdComment.DataSource = BAL.BALFactory.Instance.BAL_Comment.ShowAll(Ob);
grdComment.DataBind();
}
public DataSet ShowAll(DTO.Comment Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_CommentMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 3);
ds = PrjClass.GetData(cmd);
return(ds);
}
public string DeleteComment(DTO.Comment Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "sp_CommentMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CommentID", Ob.CommentID);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveCommentMaster(DTO.Comment Ob)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_CommentMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CommentName", Ob.CommentName);
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public static Model.Comment TranslateDTOCommentToModelComment(DTO.Comment c)
{
if (c == null)
{
return(null);
}
return(new Model.Comment
{
Id = c.Id,
LastModified = c.LastModified,
LastModifiedByUser = UserMapper.TranslateDTOUserToModelUser(c.LastModifiedByUser),
Text = c.Text
});
}
protected void btnEdit_Click(object sender, EventArgs e)
{
string res = "";
Ob = SetValue();
res = BAL.BALFactory.Instance.BAL_Comment.UpdateCommentMaster(Ob);
if (res == "Record Saved")
{
lblMsg.Text = res;
setDefault();
}
else
{
lblErr.Text = res;
}
}
public string SaveCommentMaster(DTO.Comment Ob)
{
return(DAL.DALFactory.Instance.DAL_Comment.SaveCommentMaster(Ob));
}
public string DeleteComment(DTO.Comment Ob)
{
return(DAL.DALFactory.Instance.DAL_Comment.DeleteComment(Ob));
}
public DataSet ShowAll(DTO.Comment Ob)
{
return(DAL.DALFactory.Instance.DAL_Comment.ShowAll(Ob));
}
public DataSet BindGridView(DTO.Comment Ob)
{
return(DAL.DALFactory.Instance.DAL_Comment.BindGridView(Ob));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Ob = SetValue();
grdComment.DataSource = BAL.BALFactory.Instance.BAL_Comment.BindGridView(Ob);
grdComment.DataBind();
}