public string saveProducerDetails(ModelProducer _model)
{
string result = string.Empty;
try
{
conn = ConntectionOpen();
SqlCommand cmd = new SqlCommand("Usp_Producers_AddEdit", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pUID", _model.UID);
cmd.Parameters.AddWithValue("@pName", _model.Name);
cmd.Parameters.AddWithValue("@pSex", _model.Sex);
cmd.Parameters.AddWithValue("@pDOB", _model.DOB);
cmd.Parameters.AddWithValue("@pBio", _model.Bio);
cmd.Parameters.AddWithValue("@pInsertedBy", "Admin");
cmd.Parameters.AddWithValue("@pMode", _model.Mode);
cmd.Parameters.Add("@pMsg", SqlDbType.NChar, 200);
cmd.Parameters["@pMsg"].Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery().ToString();
string returnedfromDB = cmd.Parameters["@pMsg"].Value.ToString();
if (result != "1")
{
result = returnedfromDB;
}
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
finally
{
conn.Close();
}
return(result);
}
public List <ModelProducer> searchProducerDetails(string producerName)
{
List <ModelProducer> list = new List <ModelProducer>();
try
{
using (cmd = new SqlCommand("Usp_Producers_AddEdit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pName", producerName);
cmd.Parameters.AddWithValue("@pMode", "Search");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
ModelProducer obj = new ModelProducer();
obj.UID = Convert.ToInt64(dr["UID"]);
obj.Name = dr["Name"].ToString();
obj.Sex = dr["Sex"].ToString();
obj.DOB = dr["DOB"].ToString();
obj.Bio = dr["Bio"].ToString();
list.Add(obj);
}
}
}
}
}
catch (Exception ex)
{ }
return(list);
}
public JsonResult SaveProducerDetails(ModelProducer pro)
{
CommonClass obj = new CommonClass();
return(Json(obj.saveProducerDetails(pro), JsonRequestBehavior.AllowGet));
}
