public DataSet GetDPOEmail(FeddbackSchema objFeedback_Schema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@DistrictId", SqlDbType.Int); param[0].Value = objFeedback_Schema.Districtid; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "usp_GetDPOEmail", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public int SaveFeedbackDeatails(FeddbackSchema objFeedback_Schema) { try { result = objFeedbackDAL.SaveFeedbackDeatails(objFeedback_Schema); return(result); } catch (Exception ex) { return(0); } }
//public Int64 SaveFeedback(Feedback_Schema objFeedback_Schema) //{ // try // { // conn = SQLHelper.OpenConnection(); // objTran = conn.BeginTransaction(); // SqlParameter[] cmmParameters = new SqlParameter[6]; // cmmParameters[0] = new SqlParameter("@Feedback_ID", SqlDbType.BigInt); // cmmParameters[0].Value = objFeedback_Schema.Feedback_ID; // cmmParameters[0].Direction = ParameterDirection.InputOutput; // cmmParameters[1] = new SqlParameter("@Name", SqlDbType.NVarChar); // cmmParameters[1].Value = objFeedback_Schema.Name; // cmmParameters[2] = new SqlParameter("@Mobile", SqlDbType.VarChar); // cmmParameters[2].Value = objFeedback_Schema.Mobile; // cmmParameters[3] = new SqlParameter("@Email_ID", SqlDbType.VarChar); // cmmParameters[3].Value = objFeedback_Schema.Email_ID; // cmmParameters[4] = new SqlParameter("@Feedback", SqlDbType.NVarChar); // cmmParameters[4].Value = objFeedback_Schema.Feedback; // cmmParameters[5] = new SqlParameter("@CreatedOn", SqlDbType.DateTime); // cmmParameters[5].Value = objFeedback_Schema.CreatedOn.ToString("dd MMM, yyyy"); // intCount = SQLHelper.ExecuteNonQuery(conn, objTran, CommandType.StoredProcedure, "spFeedbackAdd", cmmParameters); // foreach (SqlParameter param in cmmParameters) // { // if (param.ParameterName == "@Feedback_ID") // { // intCount = (Int64)param.Value; // break; // } // } // objTran.Commit(); // return intCount; // } // catch (Exception) // { // objTran.Rollback(); // return 0; // } // finally // { // SQLHelper.CloseConnection(conn); // intCount = 0; // } //} public int SaveFeedbackDeatails(FeddbackSchema objFeedback_Schema) { try { using (SqlConnection objConn = SQLHelper.OpenConnection()) { using (SqlTransaction objTran = objConn.BeginTransaction()) { try { var param = new SqlParameter[] { new SqlParameter("@Name", objFeedback_Schema.Name == null ? (object)DBNull.Value : objFeedback_Schema.Name), new SqlParameter("@contact", objFeedback_Schema.Contact == null ? (object)DBNull.Value : objFeedback_Schema.Contact), new SqlParameter("@Subject", objFeedback_Schema.Subject == null ? (object)DBNull.Value : objFeedback_Schema.Subject), new SqlParameter("@Email", objFeedback_Schema.Email == null ? (object)DBNull.Value : objFeedback_Schema.Email), new SqlParameter("@Message", objFeedback_Schema.Message == null ? (object)DBNull.Value : objFeedback_Schema.Message), new SqlParameter("@LangID", objFeedback_Schema.Langid == 0 ? 0 : objFeedback_Schema.Langid), new SqlParameter("@districtID", objFeedback_Schema.Districtid == 0 ? 0 : objFeedback_Schema.Districtid) }; int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "[Usp_DMLFeedbactDetails]", param); if (result == 1) { objTran.Commit(); return(result); } else { objTran.Rollback(); return(0); } } catch (Exception ex) { objTran.Rollback(); return(0); } } } } catch (Exception ee) { return(0); } finally { } }
public DataSet GetDPOEmail(FeddbackSchema objFeedback_Schema) { try { ds = objFeedbackDAL.GetDPOEmail(objFeedback_Schema); return(ds); } catch (Exception e) { return(null); } finally { ds = null; } }