Line 1: using System;
Line 2: using System.Collections.Generic;
Line 3: using System.Linq;
Line 4: using System.Text;
Line 5: using System.Data;
Line 6: using System.Web;
Line 7: using System.Data.SqlClient;
Line 8:
Line 9: /// <summary>
Line 10: /// Summary description for clsCaseStudies
Line 11: /// </summary>
Line 12: public class clsCaseStudies
Line 13: {
Line 14: Datamanager DBManager = new Datamanager();
Line 15: public clsCaseStudies()
Line 16: {
Line 17: //
Line 18: // TODO: Add constructor logic here
Line 19: //
Line 20: }
Line 21:
Line 22: public int CaseStudiesTransaction(int Opt, int CS_Mid, int CS_UserMid, string CS_Title, string CS_Description, string CS_Attachment1, string CS_Attachment2, string CS_Attachment3, string CS_Status, int CS_PublishedBy, string CS_PublishedOn, int UserId)
Line 23: {
Line 24: int result = 0;
Line 25: try
Line 26: {
Line 27: bool blnattemptconn = DBManager.OpenSQLConnection();
Line 28: if (blnattemptconn == false)
Line 29: {
Line 30: DBManager.CloseConnection();
Line 31: DBManager.OpenSQLConnection();
Line 32: }
Line 33: SqlCommand cmd = new SqlCommand("USP_CaseStudies");
Line 34: cmd.CommandType = CommandType.StoredProcedure;
Line 35: cmd.Connection = DBManager.myConn;
Line 36: cmd.Parameters.AddWithValue("@opt", Opt);
Line 37: cmd.Parameters.AddWithValue("@CS_Mid", CS_Mid);
Line 38: cmd.Parameters.AddWithValue("@CS_UserMid", CS_UserMid);
Line 39: cmd.Parameters.AddWithValue("@CS_Title", CS_Title);
Line 40: cmd.Parameters.AddWithValue("@CS_Description", CS_Description);
Line 41: cmd.Parameters.AddWithValue("@CS_Attachment1", CS_Attachment1);
Line 42: cmd.Parameters.AddWithValue("@CS_Attachment2", CS_Attachment2);
Line 43: cmd.Parameters.AddWithValue("@CS_Attachment3", CS_Attachment3);
Line 44: cmd.Parameters.AddWithValue("@CS_Status", CS_Status);
Line 45: cmd.Parameters.AddWithValue("@CS_PublishedBy", CS_PublishedBy);
Line 46: cmd.Parameters.AddWithValue("@CS_PublishedOn", CS_PublishedOn);
Line 47: cmd.Parameters.AddWithValue("@UserId", UserId);
Line 48:
Line 49: result = cmd.ExecuteNonQuery();
Line 50: }
Line 51: catch (Exception ex)
Line 52: {
Line 53: ex.Data.Clear();
Line 54: result = 0;
Line 55: }
Line 56: finally
Line 57: {
Line 58: DBManager.CloseConnection();
Line 59: }
Line 60: return result;
Line 61: }
Line 62:
Line 63:
Line 64: public DataSet GetCaseStudies(string GetRecords, string Name, string Title, string Status)
Line 65: {
Line 66: DataSet ds = new DataSet();
Line 67: try
Line 68: {
Line 69: DBManager.OpenSQLConnection();
Line 70: SqlCommand cmd = new SqlCommand("Usp_GetCaseStudies");
Line 71: cmd.CommandType = CommandType.StoredProcedure;
Line 72: cmd.Connection = DBManager.myConn;
Line 73: cmd.Parameters.AddWithValue("@GetRecords", GetRecords);
Line 74: cmd.Parameters.AddWithValue("@Name", Name);
Line 75: cmd.Parameters.AddWithValue("@Title", Title);
Line 76: cmd.Parameters.AddWithValue("@Status", Status);
Line 77: SqlDataAdapter da = new SqlDataAdapter();
Line 78: da.SelectCommand = cmd;
Line 79: da.Fill(ds);
Line 80: }
Line 81: catch (Exception ex)
Line 82: {
Line 83: ex.Data.Clear();
Line 84: }
Line 85: finally
Line 86: {
Line 87: DBManager.CloseConnection();
Line 88: }
Line 89: return ds;
Line 90: }
Line 91:
Line 92: public DataSet GetCaseStudiesUser(string GetRecords, string Name, string Title)
Line 93: {
Line 94: DataSet ds = new DataSet();
Line 95: try
Line 96: {
Line 97: DBManager.OpenSQLConnection();
Line 98: SqlCommand cmd = new SqlCommand("Usp_GetCaseStudiesUser");
Line 99: cmd.CommandType = CommandType.StoredProcedure;
Line 100: cmd.Connection = DBManager.myConn;
Line 101: cmd.Parameters.AddWithValue("@GetRecords", GetRecords);
Line 102: cmd.Parameters.AddWithValue("@Name", Name);
Line 103: cmd.Parameters.AddWithValue("@Title", Title);
Line 104: SqlDataAdapter da = new SqlDataAdapter();
Line 105: da.SelectCommand = cmd;
Line 106: da.Fill(ds);
Line 107: }
Line 108: catch (Exception ex)
Line 109: {
Line 110: ex.Data.Clear();
Line 111: }
Line 112: finally
Line 113: {
Line 114: DBManager.CloseConnection();
Line 115: }
Line 116: return ds;
Line 117: }
Line 118: public DataSet GetCaseStudies(int opt, int CaseStudyMid, string NameTitle)
Line 119: {
Line 120: DataSet ds = new DataSet();
Line 121: try
Line 122: {
Line 123: DBManager.OpenSQLConnection();
Line 124: SqlCommand cmd = new SqlCommand("USP_CaseStudies");
Line 125: cmd.CommandType = CommandType.StoredProcedure;
Line 126: cmd.Connection = DBManager.myConn;
Line 127: cmd.Parameters.AddWithValue("@opt", opt);
Line 128: cmd.Parameters.AddWithValue("@CS_Mid", CaseStudyMid);
Line 129: cmd.Parameters.AddWithValue("@NameTitle", NameTitle);
Line 130: SqlDataAdapter da = new SqlDataAdapter();
Line 131: da.SelectCommand = cmd;
Line 132: da.Fill(ds);
Line 133: }
Line 134: catch (Exception ex)
Line 135: {
Line 136: ex.Data.Clear();
Line 137: }
Line 138: finally
Line 139: {
Line 140: DBManager.CloseConnection();
Line 141: }
Line 142: return ds;
Line 143: }
Line 144: }
|