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