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)); }