public List <VendorObject> GetAll()
{
SqlConnection conn = new SqlConnection(_connstring);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "News_GetAll";
reader = cmd.ExecuteReader();
List <VendorObject> VendorList = new List <VendorObject>();
while (reader.Read())
{
VendorObject VenObj = new VendorObject();
{
VenObj.MsgId = reader.GetInt32(reader.GetOrdinal("MsgId"));
VenObj.DisplayMsg = reader.GetString(reader.GetOrdinal("DisplayMsg"));
VenObj.Msg_Title = reader.GetString(reader.GetOrdinal("Msg_Title"));
VenObj.Full_Message = reader.GetString(reader.GetOrdinal("Full_Message"));
}
VendorList.Add(VenObj);
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(VendorList);
}
/// <summary>
/// This method gets the list of Vendors
/// </summary>
/// <param name="userId"></param>
/// <returns>List<VendorObject></returns>
public List <VendorObject> GetVendorList(int userId)
{
List <VendorObject> vendorList = new List <VendorObject>();
int distillerId = _dl.GetDistillerId(userId);
try
{
var VendorFinalResults =
from vendRes in _db.Vendor
join vendDetails in _db.VendorDetail on vendRes.VendorID equals vendDetails.VendorID into vendDetails_join
from vendDetails in vendDetails_join.DefaultIfEmpty()
where vendRes.DistillerID == distillerId
select new
{
vendRes.VendorID,
vendRes.Name,
Note = (vendDetails.Note ?? string.Empty)
};
foreach (var vendorRes in VendorFinalResults)
{
var curVendor = new VendorObject();
curVendor.VendorId = vendorRes.VendorID;
curVendor.VendorName = vendorRes.Name;
curVendor.Note = vendorRes.Note;
vendorList.Add(curVendor);
}
}
catch (Exception e)
{
Debug.WriteLine("Error getting Vendor list : " + e);
}
return(vendorList);
}
public VendorObject GetById(int MsgId)
{
SqlConnection conn = new SqlConnection(_connstring);
SqlCommand cmd = new SqlCommand();
SqlParameter param = new SqlParameter();
SqlDataReader reader;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "News_GetById";
param = new SqlParameter("@MsgId", SqlDbType.Int, 4, "MsgId");
param.Direction = ParameterDirection.Input;
param.Value = MsgId;
cmd.Parameters.Add(param);
reader = cmd.ExecuteReader();
VendorObject VenObj = new VendorObject();
while (reader.Read())
{
VenObj.MsgId = reader.GetInt32(reader.GetOrdinal("MsgId"));
VenObj.DisplayMsg = reader.GetString(reader.GetOrdinal("DisplayMsg"));
VenObj.Msg_Title = reader.GetString(reader.GetOrdinal("Msg_Title"));
VenObj.Full_Message = reader.GetString(reader.GetOrdinal("Full_Message"));
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(VenObj);
}
protected void Page_Load(object sender, EventArgs e)
{
// cldDateOfBirth.Visible = false;
if (!IsPostBack)
{
int VendorId = 0;
string id = Convert.ToString(Request.QueryString["VendorId"]);
//
if (id != null)
{
btnVendorUpdate.Visible = true;
btnVendorAdd.Visible = false;
VendorId = Convert.ToInt32(id);
VendorRepository VenRep = new VendorRepository();
VendorObject VenObj = VenRep.GetById(VendorId);
hdnMsgId.Value = VenObj.MsgId.ToString();
txtDisplayMsg.Text = VenObj.DisplayMsg;
txtMsg_Title.Text = VenObj.Msg_Title;
txtFull_Message.Text = VenObj.Full_Message;
}
else
{
btnVendorUpdate.Visible = false;
btnVendorAdd.Visible = true;
}
}
}
public ActionResult Delete(int Id)
{
VendorObject venobj = new VendorObject();
VendorModel vendormodel = new VendorModel();
VendorRepository venrep = new VendorRepository();
venrep.Delete(Id);
return(RedirectToAction("VendorIndex", "Vendor"));
}
protected void btnVendorAdd_Click(object sender, EventArgs e)
{
VendorObject VenObj = new VendorObject();
VenObj.DisplayMsg = txtDisplayMsg.Text;
VenObj.Msg_Title = txtMsg_Title.Text;
VenObj.Full_Message = Convert.ToString(txtFull_Message.Text);
VendorRepository VenRep = new VendorRepository();
VenRep.Add(VenObj);
Response.Redirect("VendorList.aspx");
}
public ActionResult Edit(VendorModel vendormodel)
{
VendorObject venobj = new VendorObject();
venobj.MsgId = vendormodel.MsgId;
venobj.DisplayMsg = vendormodel.DisplayNo;
venobj.Msg_Title = vendormodel.Msg_Title;
venobj.Full_Message = vendormodel.Full_Message;
_vendor.Update(venobj);
return(RedirectToAction("vendorIndex", "Vendor"));
}
public ActionResult Edit(int Id)
{
VendorObject venobj = new VendorObject();
VendorModel vendormodel = new VendorModel();
VendorRepository venrep = new VendorRepository();
venobj = venrep.GetById(Id);
vendormodel.MsgId = venobj.MsgId;
vendormodel.DisplayNo = venobj.DisplayMsg;
vendormodel.Msg_Title = venobj.Msg_Title;
vendormodel.Full_Message = venobj.Full_Message;
return(View(vendormodel));
}
public int Update(VendorObject VenObj)
{
int retval = 0;
SqlConnection conn = new SqlConnection(_connstring);
SqlCommand cmd = new SqlCommand();
SqlParameter param = new SqlParameter();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "News_Update";
param = new SqlParameter("@MsgId", SqlDbType.Int, 4, "MsgId");
param.Direction = ParameterDirection.Input;
param.Value = VenObj.MsgId;
cmd.Parameters.Add(param);
param = new SqlParameter("@DisplayMsg", SqlDbType.VarChar, 1000, "DisplayMsg");
param.Direction = ParameterDirection.Input;
param.Value = VenObj.DisplayMsg;
cmd.Parameters.Add(param);
param = new SqlParameter("@Msg_Title", SqlDbType.VarChar, 1000, "Msg_Title");
param.Direction = ParameterDirection.Input;
param.Value = VenObj.Msg_Title;
cmd.Parameters.Add(param);
param = new SqlParameter("@Full_Message", SqlDbType.VarChar, 1000, "Full_Message");
param.Direction = ParameterDirection.Input;
param.Value = VenObj.Full_Message;
cmd.Parameters.Add(param);
retval = cmd.ExecuteNonQuery();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(retval);
}
/// <summary>
/// UpdateVendor method updates Vendor table and a note value in Notes table if Note hasn't been changed
/// </summary>
/// <param name="vendorObject"></param>
/// <param name="userId"></param>
/// <returns>bool</returns>
public bool UpdateVendor(int userId, VendorObject vendorObject)
{
//define method execution return value to be false by default
var retMthdExecResult = false;
int distillerId = _dl.GetDistillerId(userId);
if (vendorObject != null)
{
try
{
var recs =
from rec in _db.Vendor
where rec.VendorID == vendorObject.VendorId && rec.DistillerID == distillerId
select rec;
var vendorItem = recs.FirstOrDefault();
if (vendorItem.Name != vendorObject.VendorName || vendorObject.Note != string.Empty)
{
vendorItem.Name = vendorObject.VendorName;
_db.SaveChanges();
}
var recs1 =
from rec1 in _db.VendorDetail
where rec1.VendorID == vendorObject.VendorId
select rec1;
var vendorItem1 = recs1.FirstOrDefault();
if (vendorItem1.Note != vendorObject.Note || vendorObject.Note != null)
{
vendorItem1.Note = vendorObject.Note;
_db.SaveChanges();
}
retMthdExecResult = true;
}
catch (Exception e)
{
Debug.WriteLine("Failed updating vendor record: " + e);
retMthdExecResult = false;
}
}
return(retMthdExecResult);
}
public ActionResult Add(VendorModel vendormodel)
{
if (ModelState.IsValid)
{
VendorObject venobj = new VendorObject();
venobj.DisplayMsg = vendormodel.DisplayNo;
venobj.Msg_Title = vendormodel.Msg_Title;
venobj.Full_Message = vendormodel.Full_Message;
_vendor.Add(venobj);
}
else
{
return(View(vendormodel));
}
return(RedirectToAction("VendorIndex", "Vendor"));
}
/// <summary>
/// CreateVendor Method inserts new record in Vendor table and also updates Note table if there is a note
/// </summary>
/// <param name="vendorObject"></param>
/// <param name="userId"></param>
/// <returns>int</returns>
public int CreateVendor(int userId, VendorObject vendorObject)
{
//define method execution return value to be false by default
int retMthdExecResult = 0;
int distillerID = _dl.GetDistillerId(userId);
if (vendorObject != null)
{
try
{
Vendor tbl = new Vendor();
tbl.Name = vendorObject.VendorName;
tbl.DistillerID = distillerID;
_db.Vendor.Add(tbl);
_db.SaveChanges();
VendorDetail tbl1 = new VendorDetail();
if (vendorObject.Note != string.Empty && vendorObject.Note != null)
{
tbl1.Note = vendorObject.Note;
}
tbl1.VendorID = tbl.VendorID;
_db.VendorDetail.Add(tbl1);
_db.SaveChanges();
retMthdExecResult = tbl.VendorID;
}
catch (Exception e)
{
retMthdExecResult = 0;
throw e;
}
}
else
{
retMthdExecResult = 0;
}
return(retMthdExecResult);
}
public JsonResult CreateVendor(VendorObject vendorObject)
{
if (vendorObject != null)
{
if (User.Identity.IsAuthenticated)
{
int userId = User.Identity.GetUserId <int>();
if (userId > 0)
{
int returnResult = _dictionary.CreateVendor(userId, vendorObject);
if (returnResult > 0)
{
string message = "Vendor dictionary record created successfully.";
return(Json(message));
}
else
{
string message = "Failed to create vendor dictionary record!";
return(Json(message));
}
}
else
{
return(Json("Unable to find UserId!"));
}
}
else
{
return(Json("Unauthenticated user!"));
}
}
else
{
return(Json("Back End received empty or undefined Vendor Object from the client"));
}
}
