public static FormAttributeResult AddFarmProducts(int FarmId, int LkProductCrop, DateTime StartDate) { try { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "AddFarmProducts"; command.Parameters.Add(new SqlParameter("FarmId", FarmId)); command.Parameters.Add(new SqlParameter("LkProductCrop", LkProductCrop)); command.Parameters.Add(new SqlParameter("StartDate", StartDate.ToShortDateString() == "1/1/0001" ? System.Data.SqlTypes.SqlDateTime.Null : StartDate)); SqlParameter parmMessage = new SqlParameter("@isDuplicate", SqlDbType.Bit); parmMessage.Direction = ParameterDirection.Output; command.Parameters.Add(parmMessage); SqlParameter parmMessage1 = new SqlParameter("@isActive", SqlDbType.Int); parmMessage1.Direction = ParameterDirection.Output; command.Parameters.Add(parmMessage1); command.CommandTimeout = 60 * 5; command.ExecuteNonQuery(); FormAttributeResult acs = new FormAttributeResult(); acs.IsDuplicate = DataUtils.GetBool(command.Parameters["@isDuplicate"].Value.ToString()); acs.IsActive = DataUtils.GetBool(command.Parameters["@isActive"].Value.ToString()); return acs; } } } catch (Exception ex) { throw ex; } }
public static FormAttributeResult AddApplicantApplicant(int ApplicantId, int AttachedApplicantId) { try { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "AddApplicantApplicant"; command.Parameters.Add(new SqlParameter("ApplicantId", ApplicantId)); command.Parameters.Add(new SqlParameter("AttachedApplicantId", AttachedApplicantId)); SqlParameter parmMessage = new SqlParameter("@isDuplicate", SqlDbType.Bit); parmMessage.Direction = ParameterDirection.Output; command.Parameters.Add(parmMessage); SqlParameter parmMessage1 = new SqlParameter("@isActive", SqlDbType.Int); parmMessage1.Direction = ParameterDirection.Output; command.Parameters.Add(parmMessage1); command.CommandTimeout = 60 * 5; command.ExecuteNonQuery(); FormAttributeResult acs = new FormAttributeResult(); acs.IsDuplicate = DataUtils.GetBool(command.Parameters["@isDuplicate"].Value.ToString()); acs.IsActive = DataUtils.GetBool(command.Parameters["@isActive"].Value.ToString()); return acs; } } } catch (Exception ex) { throw ex; } }