public IActionResult AddCompanyRequirement(CompanyRequirementRequest company)
{
try
{
bool success = false;
string message;
var data = _companyBusiness.AddCompanyRequirement(company);
if (data != null)
{
success = true;
message = "Company Requirement Added Successfully";
return(Ok(new { success, message, data }));
}
else
{
message = "Try Again!";
return(NotFound(new { success, message }));
}
}
catch (Exception ex)
{
return(BadRequest(new { ex.Message }));
}
}
public CompanyRequirementResponse AddCompanyRequirement(CompanyRequirementRequest companyRequirement)
{
var responseData = _companyRepository.AddCompanyRequirement(companyRequirement);
return(responseData);
}
/// <summary>
/// It Stores data in the Database
/// </summary>
/// <param name="companyRequirement"></param>
/// <returns>If Data Added Successfully return ResponseData else null or Exception</returns>
public CompanyRequirementResponse AddCompanyRequirement(CompanyRequirementRequest companyRequirement)
{
try
{
CompanyRequirementResponse responseData = null;
using (SqlConnection conn = new SqlConnection(sqlConnectionString))
{
SqlCommand cmd = new SqlCommand("spAddCompanyRequirement", conn)
{
CommandType = System.Data.CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@CompanyID", companyRequirement.CompanyID);
cmd.Parameters.AddWithValue("@RequestedMonth", companyRequirement.RequestedMonth);
cmd.Parameters.AddWithValue("@City", companyRequirement.City);
cmd.Parameters.AddWithValue("@IsDocVerified", companyRequirement.IsDocVerified);
cmd.Parameters.AddWithValue("@RequirementDocPath", companyRequirement.RequirementDocPath);
cmd.Parameters.AddWithValue("@NumOfEngg", companyRequirement.NumOfEngg);
cmd.Parameters.AddWithValue("@TechStackID", companyRequirement.TechStackID);
cmd.Parameters.AddWithValue("@TechTypeID", companyRequirement.TechTypeID);
cmd.Parameters.AddWithValue("@MakerProgramID", companyRequirement.MakerProgramID);
cmd.Parameters.AddWithValue("@LeadID", companyRequirement.LeadID);
cmd.Parameters.AddWithValue("@IdeationEnggID", companyRequirement.IdeationEnggID);
cmd.Parameters.AddWithValue("@BuddyEnggID", companyRequirement.BuddyEnggID);
cmd.Parameters.AddWithValue("@SpecialRemark", companyRequirement.SpecialRemark);
cmd.Parameters.AddWithValue("@Status", companyRequirement.Status);
cmd.Parameters.AddWithValue("@CreatorStamp", companyRequirement.CreatorStamp);
cmd.Parameters.AddWithValue("@CreatorUser", companyRequirement.CreatorUser);
cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
conn.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
responseData = new CompanyRequirementResponse()
{
ID = Convert.ToInt32(dataReader["RequirementID"]),
CompanyID = Convert.ToInt32(dataReader["CompanyID"]),
RequestedMonth = dataReader["RequestedMonth"].ToString(),
City = dataReader["City"].ToString(),
IsDocVerified = Convert.ToBoolean(dataReader["IsDocVerified"]),
RequirementDocPath = dataReader["RequirementDocPath"].ToString(),
NumOfEngg = dataReader["NumOfEngg"].ToString(),
TechStackID = Convert.ToInt32(dataReader["TechStackID"]),
TechTypeID = Convert.ToInt32(dataReader["TechTypeID"]),
MakerProgramID = Convert.ToInt32(dataReader["MakerProgramID"]),
LeadID = Convert.ToInt32(dataReader["LeadID"]),
IdeationEnggID = Convert.ToInt32(dataReader["IdeationEnggID"]),
BuddyEnggID = Convert.ToInt32(dataReader["BuddyEnggID"]),
SpecialRemark = dataReader["SpecialRemark"].ToString(),
Status = dataReader["Status"].ToString(),
CreatorStamp = dataReader["CreatorStamp"].ToString(),
CreatorUser = dataReader["CreatorUser"].ToString(),
CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]),
ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"])
};
}
conn.Close();
}
return(responseData);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
