public string Update(GroupAddDto model)
{
string query = $"EXECUTE SP_UpdateGroup '{model.Id}' , '{model.Name}'";
var user = _db.Database.SqlQuery <string>(query).FirstOrDefault();
return(user);
}
public ReturnMessage AddGroup(GroupAddDto model)
{
string query = $"EXECUTE SP_AddGroup '{model.Name}' , '{model.CreatedBy}'";
var user = _db.Database.SqlQuery <ReturnMessage>(query).FirstOrDefault();
return(user);
}
public IHttpActionResult AddGroup([FromBody] GroupAddDto model)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Model"));
}
var result = new GroupService().AddGroup(model);
return(Ok(result));
}
public IHttpActionResult UpdateGroup([FromBody] GroupAddDto model)
{
if (!ModelState.IsValid)
{
return(BadRequest("Fill Empty Records"));
}
var result = new GroupService().Update(model);
return(Ok(result));
}
public async Task <BaseResultCRUDDto <OutPut_GroupDto> > CreateGroup(GroupAddDto addedmodel)
{
if (await groupRepository.GetByGroupName(addedmodel.GroupName) != null)
{
return new BaseResultCRUDDto <OutPut_GroupDto>()
{
ErrorMessage = "عنوان گروه از قبل به ثبت رسیده است "
}
}
;
return(await groupRepository.AddGroup(addedmodel));
}
public async Task <IActionResult> Add(GroupAddDto newGroup)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var group = await _groupService.Add(_mapper.Map <Group>(newGroup));
if (group == null)
{
return(BadRequest());
}
return(Ok(_mapper.Map <GroupResultDto>(group)));
}
public async Task <BaseResultCRUDDto <OutPut_GroupDto> > AddGroup(GroupAddDto addedmodel)
{
var AddedItem = new Group()
{
GroupName = addedmodel.GroupName
};
dbContext.Groups.Add(AddedItem);
await dbContext.SaveChangesAsync();
return(new BaseResultCRUDDto <OutPut_GroupDto>()
{
IsSuccess = true,
CRUDObject = new OutPut_GroupDto()
{
Id = AddedItem.Id, GroupName = AddedItem.GroupName
}
});
}
public async Task <IActionResult> CreateGroup(GroupAddDto model)
{
var resultAdd = await groupService.CreateGroup(model);
return(Ok(resultAdd));
}
public IHttpActionResult AddBulkGroup()
{
var httpRequest = HttpContext.Current.Request;
var form = httpRequest.Form;
var ds = new DataSet();
ReturnMessage result = new ReturnMessage();
#region Guid
string path = Path.GetRandomFileName();
path = path.Replace(".", "");
string Guid = path.Substring(0, 8);
#endregion
string CreatedBy = "";
try
{
if (httpRequest.Files.Count > 0)
{
foreach (string file in httpRequest.Files)
{
var postedFileBase = httpRequest.Files[file];
if (postedFileBase != null)
{
foreach (string key in form.AllKeys)
{
CreatedBy = form[key];
}
string fileExtension = Path.GetExtension(postedFileBase.FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
string fileLocation = HttpContext.Current.Server.MapPath("~/Uploads/") + postedFileBase.FileName + Guid;
if (File.Exists(fileLocation))
{
File.Delete(fileLocation);
}
postedFileBase.SaveAs(fileLocation);
var excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
if (fileExtension == ".xls")
{
excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (fileExtension == ".xlsx")
{
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
var dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return(null);
}
var excelSheets = new string[dt.Rows.Count];
int t = 0;
foreach (DataRow row in dt.Rows)
{
excelSheets[t] = row["TABLE_NAME"].ToString();
t++;
}
var excelConnection1 = new OleDbConnection(excelConnectionString);
string query = $"Select * from [{excelSheets[0]}]";
using (var dataAdapter = new OleDbDataAdapter(query, excelConnection1))
{
dataAdapter.Fill(ds);
}
int count = Convert.ToInt32(ds.Tables[0].Rows.Count);
for (int i = 0; i < count; i++)
{
var name = ds.Tables[0].Rows[i][0].ToString();
GroupAddDto model = new GroupAddDto {
CreatedBy = CreatedBy, Name = name
};
result = new GroupService().AddGroup(model);
}
return(Ok(result));
}
else
{
return(BadRequest("You must upload excel sheets only"));
}
}
}
}
return(BadRequest("No File Uploaded"));
}
catch (Exception e)
{
return(BadRequest(e.InnerException.ToString()));
}
}
